Monday, July 11, 2011

Data Importing

we can import the 'backpain data' by,

libname mylib'E:\ast';
data mylib.backpain;
PROC IMPORT OUT= MYLIB.BACKPAIN
DATAFILE= "E:\ast\backpain.txt"
DBMS=TAB REPLACE;
GETNAMES=YES;
DATAROW=2;
RUN;
proc print data=mylib.backpain;
run;

INFILE Command

INFILE command is used for importing data.
in our 'backpain' data , we can use the INFILE command as,

libname mylib'E:\ast';
data mylib.backpain;
infile'E:\ast\backpain.txt';
input a b$ c d;
run;
proc print data=mylib.backpain;
run;