I've been using this as a reference (http://support.sas.com/kb/24/712.html😞 /* Path to files to be read are in the DATALINES. */ /* Each file is read in turn with the same INPUT statement. */ /* The END= variable is set to 1 each time the DATA step */ /* comes to the end of a file. */ /* */ /* Read the name of the file to be read from the DATALINES and */ /* store it in FIL2READ. The file is then read in the DO WHILE */ /* loop. At the end of the file, the DO loop ends, control */ /* passes back to the top of DATA step and the process starts */ /* over again until all files have been read. */ /* */ /* The argument "dummy" in the INFILE statement is a place- */ /* holder used in place of a file reference. */ data one; infile datalines; /* Ensure fully qualified path will fit in FIL2READ */ length fil2read $40; /* Input path of file to be read from DATALINES */ input fil2read $; infile dummy filevar=fil2read end=done; do while(not done); /* Input statement for files to be read */ input @1 date date9. @11 quanity item $ price totcost; output; end; datalines; c:\temp\extfile1.txt c:\temp\extfile2.txt c:\temp\extfile3.txt ; proc print data=one; run; Here is the code I've written: /* LINK TO THE FTP */ FILENAME datain FTP DIR lrecl = 300 CD='/xxx/Xxx/xx/xx/xx' HOST='hostname' USER='username' PASS='passwd' ; /* GET THE FTP DIRECTORY LISTING */ filename dirlist ftp '' ls CD='/xxx/Xxx/xx/xx/xx' HOST='hostname' USER='username' PASS='passwd' ; /* What files are in the directory */ data dirlist; infile dirlist length=reclen; input fname $varying200. reclen; if upcase(fname)=: '201109'; run; /* PULL THE FILES IN THE DIRECTORY THAT WE ARE LOOKING FOR */ data one; set dirlist; infile dummy datain(fname) end=done; do while(not done); /* Input statement for files to be read */ PhoneNum : ?? BEST10. cust_acct_num : ?? BEST8. PhoneNum2 : ?? BEST9. Opt_in_dte : ?? YYMMDD10. status : $CHAR6. ; output; end; But using "dummy" doesn't work, because it won't take "FTPREF(filename)". If I take out dummy, it runs but looks for "fname" on the directory instead of cycling through the file names listed in table "dirlist". Any thoughts? Thanks!
... View more