Activity: Create a Macro Variable (REQUIRED)

[neophyte]

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;

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

[tom_grant]

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

[neophyte]

Hi,

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

[tom_grant]

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.

[neophyte]

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"????

[tom_grant · Accepted solution]

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;

[neophyte]

Dear Tom,

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

[sarah988]

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;

[Sobia]

thank you @tom_grant  its really helpful

[tom_grant]

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