Problem setting up the practice data for the SAS Base Certification Prep Guide using SAS Studio

jlcapozz — Wed, 17 Jun 2020 16:02:32 GMT

Please help, I am using SAS OnDemand for Academics with SAS Studio and trying to set up the practice data files. I have gone through the two training courses on SAS and I am trying to set up the data files the same way I did for the two courses. I have searched through this forum and haven't been able to fix my problem.

I saved the files to my computer, add a new Folder in SAS Studio named cert, Upload the cre8data.sas file. My issue is changing the path in the cre8data.sas file before running it. Because I took the training courses, I remembered where to find the file path for these files, by clicking on the cert folder and selecting Properties. But I don't know why that path doesn't work this time the same way it worked for the training courses. I've included screenshots of my folder and the upload path, the code I am using for the path and also the error message that I get, that the physical file does not exist. Below is the code I'm using (I left the original macro code there for reference). Could someone tell me what I am doing wrong? I don't know if my OneDrive has anything to do with it, I saw another post where that was an issue. I've tried downloading the practice files to a folder in OneDrive (where the two training courses also were, and worked) and also to my C drive. Still doesn't work. Also, this same path in OneDrive still works for the EPG2V2 second training course data files. Thank you !

/* Make sure the path macro variable points to your certification data location */
/*%let path=/folders/mypath/cert;*/
%let path=/home/u48504815/cert;

 85         /* Make sure the path macro variable points to your certification data location */
 86         /*%let path=/folders/mypath/cert;*/
 87         %let path=/home/u48504815/cert;
 88         
 89         /********************************************************************
 90          Do not modify the code below this line
 91         ********************************************************************/
 92         %macro setdelim;
 93            %global delim;
 94            %if %index(&path,%str(/)) %then %let delim=%str(/);
 95            %else %let delim=%str(\);
 96         %mend;
 97         %setdelim
 98         
 99         %macro makedata;
 100        %include "&path&delim.cre8permdata.sas";
 101        %include "&path&delim.cre8workdata.sas";
 102        %include "&path&delim.cre8flatfiles.sas";
 103        %put;
 104        %put NOTE- *******************************************************;
 105        %put NOTE- Your SAS Certification Prep Guide data files are ready.;
 106        %put NOTE- *******************************************************;
 107        %mend;
 108        %makedata;
 WARNING: Physical file does not exist, /home/u48504815/cert/cre8permdata.sas.
 ERROR: Cannot open %INCLUDE file /home/u48504815/cert/cre8permdata.sas.
 WARNING: Physical file does not exist, /home/u48504815/cert/cre8workdata.sas.
 ERROR: Cannot open %INCLUDE file /home/u48504815/cert/cre8workdata.sas.
 WARNING: Physical file does not exist, /home/u48504815/cert/cre8flatfiles.sas.
 ERROR: Cannot open %INCLUDE file /home/u48504815/cert/cre8flatfiles.sas.

Re: Problem setting up the practice data for the SAS Base Certification Prep Guide using SAS Studio

JosvanderVelden — Thu, 18 Jun 2020 19:10:26 GMT

What path do you see when you right click and select properties for the cert folder in sas studio?

Regards, Jos

Re: Problem setting up the practice data for the SAS Base Certification Prep Guide using SAS Studio

jlcapozz — Thu, 18 Jun 2020 21:50:35 GMT

This is the location. I thought I had this in the screenshot above, I was trying to give as much info as possible.

/home/u48504815/cert

Re: Problem setting up the practice data for the SAS Base Certification Prep Guide using SAS Studio

jlcapozz — Fri, 19 Jun 2020 23:30:09 GMT

I think my problem did end up having to do with OneDrive. Even though I did try it a different way/different drive. Now I have reconnected with OneDrive and I was able to get the data files to load.

topic Re: Problem setting up the practice data for the SAS Base Certification Prep Guide using SAS Studio in SAS Training Courses

Problem setting up the practice data for the SAS Base Certification Prep Guide using SAS Studio

Re: Problem setting up the practice data for the SAS Base Certification Prep Guide using SAS Studio

Re: Problem setting up the practice data for the SAS Base Certification Prep Guide using SAS Studio

Re: Problem setting up the practice data for the SAS Base Certification Prep Guide using SAS Studio