Problem Setting up Practice Data for SAS Base Certification on SAS Studio

[paulsonalec]

Hi,

I am using the "SAS Certification Prep Guide: Base Programming for SAS 9" to study for my base programming exam. I am using SAS Studio. I am having difficulty setting up the practice data relied on in the certification book. Specifically, SAS Studio is unable to locate the folder on my local Mac OSX machine. When I run the program that's supposed to set up all the practice data after adjusting to the correct folder location, I get the following error:

WARNING: Physical file does not exist, /Users/MYCOMPUTER/Downloads/base-guide-practice-data/cert/cre8permdata.sas.

ERROR: Cannot open %INCLUDE file /Users/MYCOMPUTER/Downloads/base-guide-practice-data/cert/cre8permdata.sas.

Here is the code that was submitted and downloaded from SAS:

%let path=/Users/MYCOMPUTER/Downloads/base-guide-practice-data/cert;

/********************************************************************
 Do not modify the code below this line 
********************************************************************/
%macro setdelim;
   %global delim;
   %if %index(&path,%str(/)) %then %let delim=%str(/);
   %else %let delim=%str(\);
%mend;
%setdelim

%macro makedata;
%include "&path&delim.cre8permdata.sas";
%include "&path&delim.cre8workdata.sas";
%include "&path&delim.cre8flatfiles.sas";
%put;
%put NOTE- *******************************************************;
%put NOTE- Your SAS Certification Prep Guide data files are ready.;
%put NOTE- *******************************************************;
%mend;
%makedata;

Hope this makes sense, TIA!!

[paulsonalec · Accepted solution]

I have figured this out for those interested - 

Steps in SAS Studio
1. Create new folder in the Navigation pane, I named mine 'cert'

2. Upload to the folder 'cert' the SAS codes downloaded from the link in the book

3. In the code 'cre8data.sas', replace the Path macro to be the location of the folder 'cert', which is on the SAS Server, not your local machine

4. Run 'cre8data.sas' and the desired data will populate.

Best

[Reeza]

Were you using SAS On Demand for Academics or SAS UE? I'm assuming ODA since you mention the SAS Server. Otherwise the path would be something like:

/folders/myfolders/cert/

Either way, please mark the question answered and good luck with your certification practice.

---

@paulsonalec wrote:

I have figured this out for those interested - 

Steps in SAS Studio
1. Create new folder in the Navigation pane, I named mine 'cert'

2. Upload to the folder 'cert' the SAS codes downloaded from the link in the book

3. In the code 'cre8data.sas', replace the Path macro to be the location of the folder 'cert', which is on the SAS Server, not your local machine

4. Run 'cre8data.sas' and the desired data will populate.

Best

---

[SteamedHams]

Hi Everyone,

I'm actually having issues with the data within SAS Enterprise Guide - any tips?

Cheers,

Steamed Hams

[Reeza]

Did you follow the EG instructions? Verify the path set up is correct and makes sense.

[Reeza]

See here:
https://communities.sas.com/t5/SAS-Programming/Proc-Contents-Basic-Question-on-Path/m-p/566365#M1591...

[DavidBrown]

SOLVED IT!

My issue was a OneDrive problem. When I downloaded the practice data, it put it in the OneDrive copy of the SASUniversityEdition folder and not the folder on the C: drive, even though I select the SASUniversityEdition folder under "This PC". 

I downloaded the zip file to my Downloads folder and moved the base-guide-practice-data folder (containing the cert folder and other documents) to the SASUniversityEdition folder on my C: drive by expanding "OS (C:)" and selecting that folder. 

Once I did that, it showed up in UniversityEdition SAS Studio under My Folders. 

Whewww!

[sabisw]

@DavidBrown Could you post your Log? 

[DavidBrown]

@sabisw I fixed the issue and edited my post to remove my unsavory comment.