topic Programming1 Lesson 2: Accessing Data in SAS Studio

Programming1 Lesson 2: Accessing Data

cristiangaribay — Wed, 05 Dec 2018 04:35:39 GMT

I am having trouble with the first activity in Lesson 2.

"Write a PROC CONTENTS step to generate a report of the storm_summary.sas7bdattable.

SAS Studio: Specify the path to your EPG194/data folder and the full name of the table."

I am using SAS Studio to run the Statement but i keep getting an error. Below are different ways i am writing the statement and i keep getting the following errors: ERROR: File FILEPATH/storm_summary.sas7bdat does not exist.

ERROR: File EPG194/storm_summary.sas7bdat does not exist.

ERROR: File EPG194/data/storm_summary.sas7bdat does not exist.

proc contents data="EPG194/data/storm_summary.sas7bdat";
run; 

proc contents data="FILEPATH/storm_summary.sas7bdat";
run;

proc contents data="EPG194/storm_summary.sas7bdat";
run;

Any help is appreciated!!

Re: Programming1 Lesson 2: Accessing Data

Reeza — Wed, 05 Dec 2018 04:46:25 GMT

I'm fairly certain that 'file path' is an actual path, not file path. I think it's a macro variable you set up when you start? Try changing it to &filepath or to the location of where you stored those files. If you're using SAS UE, it may be in the form, "/folders/myfolders/EPG194/...."

Re: Programming1 Lesson 2: Accessing Data

cristiangaribay — Wed, 05 Dec 2018 05:17:36 GMT

Hi Reeza,

I tried this Statement:

proc contents data="&filepath/storm_summary.sas7bdat";
run;

and got this error message and warning:

WARNING: Apparent symbolic reference FILEPATH not resolved.

ERROR: Path "&filepath" does not exist.

This is the answer that is being listed:

I added snapshots on how i organized the file.

Re: Programming1 Lesson 2: Accessing Data

Cynthia_sas — Wed, 05 Dec 2018 15:15:51 GMT

Hi:
It looks like you have the data in your SAS Studio folders. So what you need to do is right click on the EPG194/data folder and select Properties. It looks like you are using SAS OnDemand for Academics. What you should see in Properties is a fully qualified path that starts:
/home/<youruserID>/EPG194/data

If you copy that path and replace the word "FILEPATH" with the fully qualified path from Properties, the code should run. Please consider this view of MY SAS OnDemand account and the PROC CONTENTS to run for Storm_Summary.sas7bdat:

Hope this helps clarify that anytime you see FILEPATH in the instructions, you are meant to replace that string with YOUR location, as shown above.

Cynthia

Re: Programming1 Lesson 2: Accessing Data

cristiangaribay — Mon, 14 Jan 2019 22:49:09 GMT

Worked perfectly. Appreciate the help!

Re: Programming1 Lesson 2: Accessing Data

stephaneb2017 — Sat, 26 Jan 2019 02:12:44 GMT

I confirm as well for me, a bit tricky

here my proc:

proc contents data="/home/name/EPG194/data/storm_summary.sas7bdat";
run;

Re: Programming1 Lesson 2: Accessing Data

Cynthia_sas — Sat, 26 Jan 2019 02:23:33 GMT

Hi:
I assume that your userid is NOT "name". For example, if your userid is johndoe0, then the correct path would be:
data="/home/johndoe0/EPG194/data/storm_summary.sas7bdat"

and if your userid for the SAS OnDemand server was franbell, then the data= option would be:
data="/home/franbell/EPG194/data/storm_summary.sas7bdat"

Later on in the course, we'll show you how to make a "nickname" or a library reference for the long path, so you won't have to keep typing
/home/youruserid/EPG194/data to point to your data folder.

Cynthia

Re: Programming1 Lesson 2: Accessing Data

am1231 — Thu, 16 May 2019 14:28:54 GMT

Your advice and visuals worked for me as well! Thank you!

Re: Programming1 Lesson 2: Accessing Data

ideamonkabhi — Wed, 22 May 2019 11:12:55 GMT

proc contents data="/home/&sysuserid/EPG194/data/storm_summary.sas7bdat";
run;

Re: Programming1 Lesson 2: Accessing Data

dilwariac — Sun, 14 Jul 2019 07:48:07 GMT

Hello Cynthia,

Can you please guide how to use the correct version of SAS rather using SAS on Demand for Academics? Thanks a lot in advance!!

Re: Programming1 Lesson 2: Accessing Data

Cynthia_sas — Sun, 14 Jul 2019 15:58:41 GMT

Hi:

I don't understand what you mean by "correct" -- SAS OnDemand for Academics is a client/server version of SAS, with SAS Studio as the client and with the server software on our cloud server. What is on the server is "correct" SAS. Is it a single user copy of SAS? No? But there are many people who use client/server versions of SAS. Some use Enterprise Guide as the client software, some use SAS Studio as the client software and some use other software applications (Enterprise Miner, SAS Add-in for Microsoft Office, SAS Visual Analytics) as their client method or interface to access SAS.

Anyone can use SAS OnDemand for Academics as a zero footprint, browser-based, free way of using SAS for non-commercial learning purposes.

If you want a different version of SAS Software to use, you either have to buy it or use it under a work or school license.

Cynthia

Re: Programming1 Lesson 2: Accessing Data

LisaTran — Sat, 21 Sep 2019 16:51:07 GMT

it works. thank you

Re: Programming1 Lesson 2: Accessing Data

u43388129 — Tue, 24 Sep 2019 19:17:11 GMT

what is the answer to the number of observations?

please help

Re: Programming1 Lesson 2: Accessing Data

Cynthia_sas — Tue, 24 Sep 2019 19:56:24 GMT

Hi:
It is our intention for you to run programs so you can answer that question yourself, by running the programs for the activities and practices.

If you want to find the number of observations after running PROC CONTENTS, look at the top of the output in the Results window. For example, running PROC CONTENTS on SASHELP.CLASS as shown below:

proc contents data=sashelp.class;

run;

proc contents data='<fully qualified path and file name>';

run;

Results (partial):

Look at the highlighted part of the table for Observations -- this is the number of observations or rows. The other number -- variables -- represents the number of columns or variables.

Cynthia

Re: Programming1 Lesson 2: Accessing Data

u43388129 — Tue, 24 Sep 2019 19:55:32 GMT

Found it! Thanks ##- Please type your reply above this line. No
attachments. -##

Re: Programming1 Lesson 2: Accessing Data

scrita — Sun, 29 Sep 2019 06:06:40 GMT

Thanks! That worked for me as well!

Re: Programming1 Lesson 2: Accessing Data

stephierose1 — Fri, 08 Jan 2021 15:23:30 GMT

Thank you Cynthia! This helped me find the path. I which SAS included this instruction in their e-learning video before they asked this question.

Re: Programming1 Lesson 2: Accessing Data

Cynthia_sas — Fri, 08 Jan 2021 16:03:09 GMT

Hi:

For every interface that uses SAS Studio, in the instructions that students are provided, each set of instructions contains information about using the Properties window as highlighted in cyan, below. The information about the Properties window will work to find folder path names and for individual file path names

SAS OnDemand for Academics:

SAS University Edition:

SAS Studio with a local install of SAS on Windows:

Hope this helps,

Cynthia

Re: Programming1 Lesson 2: Accessing Data

stephierose1 — Sat, 09 Jan 2021 18:09:04 GMT

Interesting. I must have overlooked these instructions when setting up SAS studio since it was not relevant to setting up. I did notice that after I completed this particular practice that the instructions for the next practice included how to find the filepath. It would have been nice if the reminder had occurred in the first activity that I was being asked for the filepath instead of the second. I am trying to make sure that I understand every step and how to get the solution before I move forward, which is why I ended up googling how to find the filepath which led to this post. Thank you for your response Cynthia. I will be sure to refer back to set-up instructions in the future if I have any additional clarification questions as I move along.

Re: Programming1 Lesson 2: Accessing Data

sobi_shan — Thu, 18 Mar 2021 10:49:41 GMT

how can we copy the file path? do we need to type it?