Greetings, I am using an unnamed pipe access method and filevar option to read multiple files from a directory. The directory letter in my macro variable (P) is not the directory the error message (C hard-drive) references. Why isn't the filevar option pointing to the indicated directory? I can run a directory list using the filename statement, so the pipe is working correctly. Thanks in advance for your review. ERROR MESSAGE - " Physical file does not exist, C:\Documents and Settings\....txt. CODE %let my_dir = P:\PCP\Data\from_JMG; filename indata pipe "dir ""%unquote(&my_dir.*.txt)"" /b"; data JMG; lenght fil2read $256; infile indata ; input f2r $60.; fil2read='&my_dir'||f2r; infile __test filevar=fil2read truncover end=done; do while (not done); input Member__ $1. Alternate_Member__ $7. Subscr__ $50. Medicare_Id $14. Medicaid_Id $10. Mem_Last_Name $90. Mem_First_Name $90. Mem_Initial $7. Mem_DOB mmddyy10. PCP_Sys_ID best32. Do_Not_Verify $1. PCP_Att__Method best32. Verify_Date yymmdd10. Prov_NPI best32. Prov_Last_Name $16. Prov_First_Name $10. Prov_Initial $1. Practice_NPI $10. Practice_Name $52. Comments $74. Plan_ID best32. Plan_Name $20. Finacial_Class $17. ; output; end; run;
... View more