topic Re: Activity: Create a Macro Variable (REQUIRED) in SAS Studio

Activity: Create a Macro Variable (REQUIRED)

neophyte — Tue, 10 Jan 2023 19:31:06 GMT

Hi,

I am totally lost in this setup, please help, I am using SAS Studio 9.4

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.

Re: Activity: Create a Macro Variable (REQUIRED)

tom_grant — Tue, 10 Jan 2023 19:41:38 GMT

Are you using a local install of SAS or SAS OnDemand for Academics?

Re: Activity: Create a Macro Variable (REQUIRED)

neophyte — Tue, 10 Jan 2023 19:55:25 GMT

Hi,

I am using SAS studio for an e-learning virtual Lab.

Re: Activity: Create a Macro Variable (REQUIRED)

tom_grant — Tue, 10 Jan 2023 20:12:45 GMT

Using the SAS Virtual Lab
The SAS Virtual Lab already has the course files loaded for you. All you have to do is launch the lab and start using SAS Studio.
So I think it would be:
%let outpath=S:/workshop/EPG1V2/data

Note: In some programs in this course you will be asked to replace FILEPATH with the path to your EPG1V2/data folder. For the virtual lab your filepath is S:/workshop/EPG1V2/data. You can view and copy the filepath anytime by right-clicking the data folder and selecting Properties.

Re: Activity: Create a Macro Variable (REQUIRED)

neophyte — Tue, 10 Jan 2023 20:24:36 GMT

Dear Tom,

Thank you very much for your time and efforts, please help me more

step 1: In your EPG1V2 folder, open libname.sas.

So Libname.sas is in Demo folder so when I open it, and then I will have to add
Macro.

actual file:

libname pg1 "S:/workshop/EPG1V2/data";
run;

Creating Macro:
%let outpath="S:/workshop/EPG1V2/data";
libname pg1 "S:/workshop/EPG1V2/data";
run;

and then I will run and below is the result:

NOTE: The SAS System stopped processing this step because of errors.
98 proc export data=pg1.storm_final
99 outfile="&outpath/storm_final.csv"
NOTE: Line generated by the macro variable "OUTPATH".
99 ""S:/workshop/EPG1V2/data"????

Re: Activity: Create a Macro Variable (REQUIRED)

tom_grant — Tue, 10 Jan 2023 20:47:08 GMT

Hello - take the quotes out of the %let statement.
Should be:
%let outpath = S:/workshop/EPG1V2/data;
however the exercise may want you to write the file to another directory under S:/workshop/EPG1V2/ - is there a folder under S:/workshop/EPG1V2/ called output or something like that? If so, then your %let statement should be:
%let outpath = S:/workshop/EPG1V2/output;

Re: Activity: Create a Macro Variable (REQUIRED)

tom_grant — Tue, 10 Jan 2023 20:48:47 GMT

When SAS sees the &outpath it will substitute whatever is after the = in the %let statement (including quotes)

Re: Activity: Create a Macro Variable (REQUIRED)

neophyte — Tue, 10 Jan 2023 21:04:34 GMT

Dear Tom,

Thanks a lot, really appreciate your time and efforts. it solved the problem.

Re: Activity: Create a Macro Variable (REQUIRED)

sarah988 — Thu, 13 Jul 2023 09:24:20 GMT

hi, I did submit the code and I still get an error saying that my pg1.storm_final.data does not exist.

I am not sure what is the problem can you please help me?

the code

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

Re: Activity: Create a Macro Variable (REQUIRED)

Sobia — Fri, 26 Jan 2024 11:52:59 GMT

thank you @tom_grant its really helpful