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: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
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.

SAS Training: Just a Click Away

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

Browse our catalog!

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