Setting up an Output Path using SAS Studio

CherylG — Thu, 08 Aug 2019 15:24:20 GMT

I am working through the SAS Programming 1 Essentials, on the 6th module about exporting results, and I can't figure out what the filepath is for my "outpath". I am using SAS Studio and trying to create a line for %let outpath

I thought it might be %let outpath= "/folders/myfolders/EPG194/output"; which I ran within libname.sas.

But I am getting an error message when I try to do the first exercise,

Here is the code:

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

Here is the log:

NOTE: PROCEDURE EXPORT used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

NOTE: The SAS System stopped processing this step because of errors.

99 proc export data=pg1.storm_final

100 outfile="&outpath/storm_final.csv"

NOTE: Line generated by the macro variable "OUTPATH".

100 ""/folders/myfolders/EPG194/output"

ERROR 22-322: Syntax error, expecting one of the following: ;, DATA, DBLABEL, DBMS, DEBUG, FILE, LABEL, OUTFILE, OUTTABLE, REPLACE,

TABLE, _DEBUG_.

ERROR 76-322: Syntax error, statement will be ignored.

101 dbms=csv replace;

102 run;

103

104

105 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

117

Thanks in advance for your help!

Re: Setting up an Output Path using SAS Studio

CherylG — Thu, 08 Aug 2019 17:47:03 GMT

never mind - I solved it myself - removed the double quotes. sigh.

Re: Setting up an Output Path using SAS Studio

Cynthia_sas — Thu, 08 Aug 2019 19:35:59 GMT

Hi:
Yes, we do not recommend using quotes in the %LET statement -- that frequently breaks the code where you use the helper macro variable.
Cynthia

topic Setting up an Output Path using SAS Studio in Programming 1 and 2

Setting up an Output Path using SAS Studio

Re: Setting up an Output Path using SAS Studio

Re: Setting up an Output Path using SAS Studio