hi ,
I am unable to import the multiple files ...form desktop.
i could not able to trace the error in the code .. please help..
data allu.import;
input ExternalNames $ 40.;
infile filevar=ExternalNames end=Last;
do until (last);
input . . ;
output;
end;
datalines;
c:\Documents and Settings\alluraiah.ychv\Desktop\data1.txt
c:\Documents and Settings\alluraiah.ychv\Desktop\moredata.txt
c:\Documents and Settings\alluraiah.ychv\Desktop\fred.txt
;
Regards
ALLU
thanks Mr Tom...
data allu.import;
input ExternalNames $ 40.;
infile DUMMY filevar=ExternalNames end=Last;
do until (last);
input . . ;
output;
end;
datalines;
c:\Documents and Settings\alluraiah.ychv\Desktop\data1.txt
c:\Documents and Settings\alluraiah.ychv\Desktop\moredata.txt
c:\Documents and Settings\alluraiah.ychv\Desktop\fred.txt
;
In addition to adding a fileref to the INFILE statement you should reset LAST variable to 0 after the DO loop. Otherwise it will probably only read one line each from second file onward.
You should switch to a DO WHILE( NOT last) loop to prevent the data step from bombing when it hits an empty file.
thanks Mr Tom...
thanks..
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.