Create a Macro Variable (REQUIRED)

[Cynthia_sas]

HI:
When using SAS University Edition, a partial path is NOT recommended. So with this OUTFILE= option:
outfile= "&outpathone/test_file.csv"

The challenge is that if &OUTPATHONE is just /EPG194/output (or in the newer course /EPG1V2/output), then the resolved value would be:
outfile="/EPG194/output/test_file.csv"

And that would make SAS think that the EPG194 folder was in a relative location to a system folder. And in SAS University Edition and SAS OnDemand for Academics, this location would be WRONG.

  In the instructions, we tell you to use the full path. please go to your EPG194 folder in the Server Files and Folders pane and expand the folder. Then find the output folder and right click on the folder name and choose Properties. My guess is that you will see one of these 2 locations in the Location field of the properties window:
/home/<userID>/EPG194/output (for SAS OnDemand)
or
/folders/myfolders/EPG194/output (for SAS University Edition)

So this means that the correct %LET statement (without quotes) would be:
%let outpathone=/home/<userID>/EPG194/output; (for SAS OnDemand)
or
%let outpathone=/folders/myfolders/EPG194/output; (for SAS University Edition)

This would then make the OUTFILE= option resolve to:

outfile="/home/<userID>/EPG194/output/test_file.csv" (for SAS OnDemand)

or

outfile="/folders/myfolders/EPG194/output/test_file.csv"

Which should work for you to create the CSV file once the OUTFILE= option has the correct, full, path for the output folder.

Hope this helps,
Cynthia

[smatholi]

Thank you very much. I executed the %let statement without quotes. That was the issue and now resolved. Thanks

But wonder why %let statement didnt throw an error when I executed with quotes. 

[smatholi]

Thank you. yes I used quotes when I executed %let statement that was the issue. thanks a lot

[SASKiwi]

@smatholi  - Please update your post as answered in that case.

[shre6455]

%let outpath = /home/u61XXXX/EPG1V2/output;
run; 

(it will define the macro outpath )

outfile="&outpath/storm_final.csv"

dbms=csv replace;

run;

NOTE: 3093 records were written to the file '/home/u61XXXX/EPG1V2/output/storm_final.csv'

answer to your question is 3093

[sarah988]

hi!  I am still stuck on this question, I did everything but I still get an error in the log after submitting that storm_final does not exist. 

can someone help me please thank you.

[ballardw]

---

@sarah988 wrote:

hi!  I am still stuck on this question, I did everything but I still get an error in the log after submitting that storm_final does not exist. 

can someone help me please thank you.

---

Any time you want to ask about an error you need to do these 3 things:

1) Start your own thread on the forum, you can reference another thread such as this one by copying and paste the URL into your description

2) Copy the text of the code submitted that generated the error along with all the messages From the LOG.

3) On the forum open a text box in your problem description by clicking on the </> icon that appears above the message window and paste the copied text with the code and error messages.

The most common cause about things not existing is not following all of the step correctly in the set up instructions for your course.

Starting your own thread means that we do not have to wade through 2 year old stuff that doesn't apply directly to  your problem to find the your details. Plus as the author of the thread you have the ability to mark a solution, when made, as the correct solution.