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: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 611 views
  • 2 likes
  • 2 in conversation