Error to Create a Macro Variable in SAS Studio Practice

Jallah_Kennedy — Wed, 08 Mar 2023 16:11:11 GMT

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

In your EPG1V2 folder, open libname.sas.
Create a macro variable named outpath that stores the filepath to your EPG1V2/output folder:

%let outpath=filepath-to-output-folder;

Run the code.
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;

69 proc export data=pg1.storm.final

ERROR: "PG1.STORM.FINAL" is not a valid name.

ERROR: Invalid data set name pg1.storm.final.

Re: Error to Create a Macro Variable in SAS Studio Practice

Reeza — Wed, 08 Mar 2023 16:14:46 GMT

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?

Re: Error to Create a Macro Variable in SAS Studio Practice

Jallah_Kennedy — Wed, 08 Mar 2023 19:09:23 GMT

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

Problems solved including the macro issue.

topic Re: Error to Create a Macro Variable in SAS Studio Practice in SAS Programming

Error to Create a Macro Variable in SAS Studio Practice

Re: Error to Create a Macro Variable in SAS Studio Practice

Re: Error to Create a Macro Variable in SAS Studio Practice