INFILE statement

and 


INPUT statement

INFILE AND INPUT STATEMENTS

EX;
DATA EMP;
INFILE 'E:\ABC\EMPLOYEE.TXT' MISSOVER;
INPUT VAR1 VAR 2....VARN;
RUN;

using proc import,infile and input

using infile and input statements must it is possible to
clean and get the data into in u r environment....

some body says using proc import using proc import it is not
possible to clean and get the data in u r
environment..................it will take as it is

whenever the data  in .txt .dat format we can directly us 
infile and input statements.
but incase of .xls
it is not possible to read excel data file directly through 
infile input.
we have to use:
wizard
DDE(dynamic data exchange) 
proc import (its best one)
(in projects we go for proc import only)
after reading into sas session we will go for cleaning.

input & infile

we can import the an external file in three ways to a sas 
data set 
1.libname libref<location of the sas data set library>;
  filname fileref<path of the raw data file>;
  data <data set name>;
  infile <fileref>;
  input <variable declarations>;
  run;
2.proc import 

3.by using the proc import option in the sas wizard of file 
menu option.