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..
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.