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 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
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.
Ready to level-up your skills? Choose your own adventure.