BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
Jallah_Kennedy
Fluorite | Level 6

Please help me solve this issue to create the macro for the path.

I read some of the solutions in the SAS Community but I still cannot solve it. Thanks.

Activity: Create a Macro Variable (REQUIRED)

Follow the instructions for your software to create a macro variable that stores the location for output files.

SAS Studio
    1. In your EPG1V2 folder, open libname.sas.

    2. Create a macro variable named outpath that stores the filepath to your EPG1V2/output folder:
%let outpath=filepath-to-output-folder; 
  1. Run the code.

  2. Check the log to be sure there are no errors, then save and close the program.

 

When I replaced the italicized with this: /home/u49276441/EPG1V2/output

and tried to run this:

proc export data=pg1.storm_final
     outfile="&outpath/storm_final.csv"
     dbms=csv replace;
run; 

I get these errors:
1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
68
69 proc export data=pg1.storm.final
ERROR: "PG1.STORM.FINAL" is not a valid name.
ERROR: Invalid data set name pg1.storm.final.
1 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User
Your log doesn't appear to match the code.

pg1.storm_final versus
pg1.storm.final

period versus underscore.

Can you show the full log and code please?

View solution in original post

2 REPLIES 2
Reeza
Super User
Your log doesn't appear to match the code.

pg1.storm_final versus
pg1.storm.final

period versus underscore.

Can you show the full log and code please?
Jallah_Kennedy
Fluorite | Level 6

Thanks @Reeza  for the quick and very useful help. Much appreciated.

Problems solved including the macro issue.

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

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
  • 2 replies
  • 557 views
  • 2 likes
  • 2 in conversation