topic Re: unable to read multiple files !! in SAS Programming

unable to read multiple files !!

allurai0412 — Mon, 11 Feb 2013 14:13:27 GMT

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

Re: unable to read multiple files !!

DBailey — Mon, 11 Feb 2013 14:35:20 GMT

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

;

Re: unable to read multiple files !!

Tom — Mon, 11 Feb 2013 14:51:56 GMT

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.

Re: unable to read multiple files !!

allurai0412 — Mon, 11 Feb 2013 17:14:13 GMT

thanks..

Re: unable to read multiple files !!

allurai0412 — Mon, 11 Feb 2013 17:14:32 GMT

thanks Mr Tom...