unable to read multiple files !!

[allurai0412]

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

[DBailey]

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

;

[Tom]

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.

[allurai0412 · Accepted solution]

thanks  Mr Tom...

[allurai0412]

thanks..