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..
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.