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..
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.