DATA Step, Macro, Functions and more

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

Reply
Contributor
Posts: 56

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

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

Super User
Posts: 13,950

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

Posted in reply to tobyfarms

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.

Super User
Super User
Posts: 8,289

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

Posted in reply to tobyfarms

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".

Super User
Posts: 24,027

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

Posted in reply to tobyfarms

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. 

Ask a Question
Discussion stats
  • 3 replies
  • 137 views
  • 0 likes
  • 4 in conversation