Archive für 18.11.2007

Import external data or files into SAS using wildcards

If you want to import all files of a folder with a specific name or type you can use wildcards to store them in a SAS dataset.
You can use this example:

/*
this datastep will import all
ASC files of the specified folder
*/
data WORK.share;
infile ‘D:\yourPath\*.asc’
delimiter=’09′x
MISSOVER
DSD
lrecl=32767 ;
format date mmddyy10. ;
informat date mmddyy10. ;
input
date
;
run;

|