BookmarkSubscribeRSS Feed
tobyfarms
Fluorite | Level 6

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

3 REPLIES 3
ballardw
Super User

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.

Tom
Super User Tom
Super User

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

Reeza
Super User

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. 

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 990 views
  • 0 likes
  • 4 in conversation