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

[jlcapozz]

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.

[JosvanderVelden]

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

Regards, Jos

[jlcapozz]

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

[jlcapozz · Accepted solution]

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.