BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
DUBS
Fluorite | Level 6

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Cynthia_sas
SAS Super FREQ
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

View solution in original post

4 REPLIES 4
pink_poodle
Barite | Level 11

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#n00bih...

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

DUBS
Fluorite | Level 6

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!

Cynthia_sas
SAS Super FREQ
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

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

LIBNAME 101

Follow along as SAS technical trainer Dominique Weatherspoon expertly answers all your questions about SAS Libraries.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 1263 views
  • 3 likes
  • 3 in conversation