topic Re: Trouble Accessing Practice Data from SAS Certified Soecialist Prep Guide in Programming 1 and 2

Trouble Accessing Practice Data from SAS Certified Soecialist Prep Guide

DUBS — Wed, 22 Mar 2023 15:21:54 GMT

Hello - I am having trouble accessing the practice data for "SAS Certified Specialist Prep Guide: Base Programming Using SAS 9.4".

I think my problem has to do with updating the macro variable: path=/folders/mypath/cert

I have tried each of the following:
C:\Users\Owner\Erik\Work\SAS Training\base-guide-practice-data\cert

'C:\Users\Owner\Erik\Work\SAS Training\base-guide-practice-data\cert'

C:/Users/Owner/Erik/Work/SAS Training/base-guide-practice-data/cert

'C:/Users/Owner/Erik/Work/SAS Training/base-guide-practice-data/cert'

In each case I get a error message that says: ERROR: Cannot open %INCLUDE file

Any help would be appreciated. Thanks!

Re: Trouble Accessing Practice Data from SAS Certified Soecialist Prep Guide

pink_poodle — Wed, 22 Mar 2023 20:23:38 GMT

Go to that location in File Explorer and look at the file.

1. It is there?

2. Is it ok?

3. Do you already have it open? (then close it)

4. If none of three cases before, try opening a file with %include that will surely work, for example:

https://documentation.sas.com/doc/en/vdmmlcdc/8.1/lestmtsref/p1s3uhhqtscz2sn1otiatbovfn1t.htm#n00bihrpksgveyn1i4sccqyilq74

5. If this works, analogously open your SAS prep file.

Re: Trouble Accessing Practice Data from SAS Certified Soecialist Prep Guide

DUBS — Mon, 27 Mar 2023 15:02:52 GMT

Thank you for your response. I confirmed that the first three points you outlined are not the issue (i.e. the file is there, it appears to be ok, and the file is not open.) I also reviewed the documentation at the link you provided. Unfortunately, I was still unable to create the practice data. I attached a document with a few screenshots. (the create data file in windows explorer, the SAS code I submitted and the SAS log with the error messages).

With this information, is there any more explicit guidance you could provide?

Thanks!

Re: Trouble Accessing Practice Data from SAS Certified Soecialist Prep Guide

Cynthia_sas — Mon, 27 Mar 2023 15:59:05 GMT

Hi:
It's a bit hard to tell from your screenshots, but it looks like you are using SAS OnDemand for Academics on the SAS OnDemand cloud server. If this is the case (if you go to https://welcome.oda.sas.com to start SAS Studio) then you cannot point to C: drive files using the OnDemand SAS Studio access.
You will need to create a "cert" folder under your Files (Home) top folder on the SAS OnDemand server and then upload the "cert" files from your C: drive location up to the OnDemand folder. Then, after you do the upload, you should right click on the cert folder under Files (Home) and select Properties. The location on the OnDemand folder should appear in the Location field of the Properties window. This is the path you should use, not a C: drive path. The path should be something like:
/home/u1234567/cert
where u1234567 is your OnDemand user ID.
Cynthia

Re: Trouble Accessing Practice Data from SAS Certified Soecialist Prep Guide

DUBS — Mon, 27 Mar 2023 16:12:30 GMT

BINGO! Thanks!