topic Re: Problem Setting up Practice Data for SAS Base Certification on SAS Studio in SAS Studio

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

paulsonalec — Fri, 15 Mar 2019 20:28:00 GMT

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!!

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

paulsonalec — Fri, 15 Mar 2019 20:42:19 GMT

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

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

Reeza — Sat, 16 Mar 2019 02:27:25 GMT

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

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

SteamedHams — Mon, 17 Jun 2019 08:45:24 GMT

Hi Everyone,

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

Cheers,

Steamed Hams

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

Reeza — Mon, 17 Jun 2019 15:15:22 GMT

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

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

Reeza — Mon, 17 Jun 2019 15:21:21 GMT

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

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

DavidBrown — Wed, 25 Mar 2020 20:40:15 GMT

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!

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

sabisw — Tue, 24 Mar 2020 21:44:50 GMT

@DavidBrown Could you post your Log?

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

DavidBrown — Wed, 25 Mar 2020 20:41:30 GMT

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