topic Re: Macro Error - Physical file does not exist, /sas/config/Lev1/SASApp/IN_DAT in SAS Programming

Macro Error - Physical file does not exist, /sas/config/Lev1/SASApp/IN_DAT

tobyfarms — Thu, 02 Nov 2017 18:42:58 GMT

This code is embedded inside of a macro, where the file location somehow changed from what the code states. Is there a way to fix within the Toolbar -Options of SAS Enterprise Guide or something that will need to changed within the Management Console?

CODE:

%get_filenames(/sas/data/imports);

LOG:

NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update mode. Temporary parameter values will be saved to

WORK.PARMS.PARMS.SLIST.

ERROR: Physical file does not exist, /sas/config/Lev1/SASApp/IN_DAT.

ERROR: Import unsuccessful. See SAS Log for details.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE IMPORT used (Total process time):

real time 0.32 seconds

cpu time 0.03 seconds

Re: Macro Error - Physical file does not exist, /sas/config/Lev1/SASApp/IN_DAT

ballardw — Thu, 02 Nov 2017 19:09:41 GMT

It is extremely likely that the macro code will need to be modified. Things like paths to files often should be parameters that can be changed as needed, such as this case.

You'll likely need to show the code for the macro for more specific suggestions.

Paste the code from the SAS editor into a code box on the forum opened using the {I} menu icon.

The note you show is sometimes associated with opening a second SAS session when one is already active. Some of your configuration information is then unavailable. That could also be related to the issue at hand.

Re: Macro Error - Physical file does not exist, /sas/config/Lev1/SASApp/IN_DAT

Tom — Thu, 02 Nov 2017 19:19:50 GMT

Given this error message:

ERROR: Physical file does not exist, /sas/config/Lev1/SASApp/IN_DAT.

Then most likely the current working directory for your SAS session is

/sas/config/Lev1/SASApp/

And your program tried to open a file named "IN_DAT".

Perhaps you meant to reference a fileref that had been created with a FILENAME statement and accidentally added quotes around the name so that SAS thought you were providing a physical name instead of the logic fileref?

If that is not it then give it a fully qualified path to the file and not just "IN_DAT".

Re: Macro Error - Physical file does not exist, /sas/config/Lev1/SASApp/IN_DAT

Reeza — Thu, 02 Nov 2017 19:33:58 GMT

You're working on a SAS server, somehow the path you're trying to use isn't recognized. Navigate to the path using the File Viewer in EG and then find the path it expects, I think it's under properties.