topic Re: Error: Physical file does not exist when doing macro import in SAS Programming

Error: Physical file does not exist when doing macro import

ac16c — Tue, 31 Oct 2017 04:53:26 GMT

I am doing a macro import of data from excel and it has worked except for a specific set of data. This data is on my computer and the format of the data is the same as the rest so I do not know why only that data has that error. I have attached these pictures which are the macro code, the error message I get for the specific data, and an example of the successful macro import for my other data.

I would appreciate any suggestions on how to fix this error.

Re: Error: Physical file does not exist when doing macro import

ChrisNZ — Tue, 31 Oct 2017 05:34:55 GMT

Show us the (trimmed if necessary) output from this:

filename DIR pipe 'dir "c:\fullpath" ';
data _null_;
  infile DIR;
  input; 
  putlog _infile_;
run;

Re: Error: Physical file does not exist when doing macro import

Kurt_Bremser — Tue, 31 Oct 2017 06:27:04 GMT

Make sure that the file is there. When SAS says a file ain't there, it ain't there, period.

It also helps to have easily usable names for paths and files:

- no blanks

- no special characters (aside from letters, digits, underlines or dots)

Sometimes an inserted special character in a filename (like a tab) might disguise as a blank and cause confusion. So instead of blanks, always use underlines.

See Maxim 44.

Re: Error: Physical file does not exist when doing macro import

Reeza — Tue, 31 Oct 2017 15:16:14 GMT

Copy the path to the file from the log. Paste it into your browser and see if the file opens. If it doesn't, the file doesn't exist. There's probably a small text anomaly with that file, ie an extra space or someone put 04 instead of 4.

Re: Error: Physical file does not exist when doing macro import

ac16c — Tue, 31 Oct 2017 21:07:25 GMT

Thank you. I had an extra space after the last character in my filename.