SAS on Demand on Mac

[Noudjoum]

Hello I am trying to use the files for the SAS certification preparation on a Mac, via SAS on Demand but it does not work. I stored the file here: /Users/noudjoumhibbert/SAS/base-guide-practice-data
I am running this program :

%let path=/myfolders/mypath/cert;

*%let path = ‎⁨Macintosh HD⁩.⁨Users.⁨noudjoumhibbert⁩.⁨SAS⁩.⁨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; 

and I am having this erros :

WARNING: Physical file does not exist, /myfolders/mypath/cert/cre8permdata.sas.
ERROR: Cannot open %INCLUDE file /myfolders/mypath/cert/cre8permdata.sas.
WARNING: Physical file does not exist, /myfolders/mypath/cert/cre8workdata.sas.
ERROR: Cannot open %INCLUDE file /myfolders/mypath/cert/cre8workdata.sas.
WARNING: Physical file does not exist, /myfolders/mypath/cert/cre8flatfiles.sas.
ERROR: Cannot open %INCLUDE file /myfolders/mypath/cert/cre8flatfiles.sas.

thanks a lot for your help. 

[Reeza]

Path should be the path to your practice files, so try using the path you indicated:

%let path = /Users/noudjoumhibbert/SAS/base-guide-practice-data;

Make sure you have only one path. 

However, I was fairly certain the On Demand paths started with home, not users. 

I would suggest navigating to the folder (assuming it's on the server) right click, select properties and get the path from there. 

Note that On Demand runs in the cloud. It cannot see or access anything on your computer unless you upload it or copy it over, it's running on a server somewhere else. 

---

@Noudjoum wrote:

Hello I am trying to use the files for the SAS certification preparation on a Mac, via SAS on Demand but it does not work. I stored the file here: /Users/noudjoumhibbert/SAS/base-guide-practice-data
I am running this program :

%let path=/myfolders/mypath/cert;

*%let path = ‎⁨Macintosh HD⁩.⁨Users.⁨noudjoumhibbert⁩.⁨SAS⁩.⁨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; 

and I am having this erros :

WARNING: Physical file does not exist, /myfolders/mypath/cert/cre8permdata.sas.
ERROR: Cannot open %INCLUDE file /myfolders/mypath/cert/cre8permdata.sas.
WARNING: Physical file does not exist, /myfolders/mypath/cert/cre8workdata.sas.
ERROR: Cannot open %INCLUDE file /myfolders/mypath/cert/cre8workdata.sas.
WARNING: Physical file does not exist, /myfolders/mypath/cert/cre8flatfiles.sas.
ERROR: Cannot open %INCLUDE file /myfolders/mypath/cert/cre8flatfiles.sas.

thanks a lot for your help. 

---

[Noudjoum · Accepted solution]

Hi Reeza,

Thanks a lot for your answer.

the path that you see in comment is the path that I copied from the get info menue on the right click +control+fn. 

I tried both paths and none of them works.

I am using the online SAS on demand, because the virtual machine does not work on my Mac. 

So how can I upload my files to the cloud? 

thanks a lot! 

[Reeza]

The virtual machine works fine on a Mac, I'm literally using it right now. If you need help with the setup, contact tech support.

Are you using AWS by chance? As Cynthia has shown, and she works for SAS, the path shouldn't be home/ so that means something else is going on here. Or are you using your own installation?
If you still think you're using Academics on Demand can you please show us some screenshots of the following:

1. Folder on the server
2. Properties on the folder showing the path

[Abhijit8855]

Virtual Machine doesn't work on new MacBook with M1 chip. I contacted support team and they said it is not compatible yet with M1.

[Reeza]

Oracle VM doesn't, VMWare and Parallels do but they'll set you back a few bucks. Living on the bleeding edge will cost you.

EDIT: Actually, On Demand doesn't require a VM so that isn't relevant to this discussion at all. It's a cloud hosted solution so it runs on the SAS servers, not your local computer. 

[Reeza]

To upload files to the cloud, go the Server Files and Folders pane, find the folder you want to upload into, click the icon that looks like an up arrow and upload the files.

[Cynthia_sas]

Hi:

  Please be very clear about how you are using SAS. Are you using SAS OnDemand for Academics or SAS University Edition in a Virtual Machine?

  SAS OnDemand for Academics is a cloud server account which you access from a web browser. There are NOT any files stored on your personal machine with SAS OnDemand -- whether you are using a Mac or a Windows machine -- you always log onto the SAS Control Center and start SAS Studio from the Control Center Dashboard. Your SAS OnDemand for Academics file locations would NEVER start with /user. For SAS OnDemand for Academics, an account is allocated 5 GB of storage space on the server and your default "root" location is ALWAYS: /home/userID -- ALWAYS.

  SAS University Edition in a Virtual Machine needs Virtual Machine hosting software like VirtualBox or VMWare Player. In this type of usage, on a Windows machine or on a Mac, you ALWAYS start your host software first and THEN start SAS Studio by entering a URL in your browser. The URL for VMWare is typically, 192.168.?.? and the URL for Virtual Box is always localhost:10080. In this case, your files go into your SASUniversityEdition/myfolders location on YOUR machine (doesn't matter if Windows or Mac). Your default "root" location for SAS University Edition is ALWAYS: /folders/myfolders -- ALWAYS, assuming you set up the shared folder definition correctly.

  If you took the free Programming 1 class, we had instructions for how to make the class data for each of the above methods. So if you were successful setting up the data for Programming 1, then you will only need to make a cert folder for the practice data instead of an EPG194 folder like you did for class.

  Hope this helps.

Cynthia

[Noudjoum]

Hi Cynthia, 

Thanks for your answer. I did not take the Programming 1 class because I work with SAS since 2009, with some interruptions du to maternity leave and then move to the US.

I never needed the certification until some people who were not able to assess my skills, decided that I needed to be certified. So this is why I needed the SAS University Edition or SAS on Demand, just to go through the cases of the prep book at home and not during my work hours. 

I went again through the installation ( some poeple on the web said they struggled for a month with it) , and I was surprised to see that I was at the end installing SAS Studio lol Now I am trying to figure out how to get the training package to generate the datasets. I might have to generate them manually but I have the funny feeling that there are some imports out there. To be honest I did not open all the programs. 

But thanks for your help!

Best regards. 

[Noudjoum]

And I just did it, I just needed to replace the pathway of these programs! I am soo happy. 

Thanks for your help everyone!!! 

[gjefferson]

Hi:

I am now attempting upload of excel file into SAS on Demand for Academics--the cloud. I have run into the following problem and suspect it is an incorrect path designation. Any suggestions?  THANK YOU!

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

70

71 PROC IMPORT DATAFILE='home/gjefferson/Desktop/FinalVTEdata2020.xlsx' DBMS=xlsx out=work.VTE;

72 SHEET='CSV';

73 RANGE='CSV$A1:N109';

74 RUN;

ERROR: Physical file does not exist, /pbr/biconfig/940/Lev1/SASApp/home/gjefferson/Desktop//FinalVTEdata2020.

[Reeza]

You need a slash in front of the home. 

If you find the file in Servers Files and Folders pane, right click it and select properties. The correct path will be in the properties section.

[gjefferson]

Thank your quick reply!
For properties my file is listed as Macintosh HD>Users>gjefferson>Desktop>FinalVTEdata2020.xlsx

I have tried /home…, /MacintoshHD…, with and without Users.

I am trulyl stumped.

[gjefferson]

thank you for your quick reply!

 this is my properties pane.

I have tried /home/gjefferson/Desktop/FinalVTE...

I have tried/MacintoshHD/gjefferson/Desktop/FinalVTE...

I have tried the path inclusive of Users as well

I have tried the path with space between Macintosh HD as well.

I am stumped. Any other suggestions? Thank you in advance!

[Reeza]

Ok, if you're using On Demand that's in the cloud. You cannot use a file on your local computer, the server in the cloud cannot see your computer files for good reason. 

In SAS Studio, find the Servers Folders and Files pane. Look at the icons in that pane. There's one with an up arrow. Click that to upload your file to the cloud to be used. 

If you're using SAS UE instead, you should have created a myfolders as part of the installation. If that's the case, move the file to that folder and then use the path as:

/folders/myfolders/fileName

Or you can follow a similar procedure to upload the file. Note that there is a limit to the file size that can be uploaded and it's low. 10 or 50MB I believe.

---

@gjefferson wrote:

thank you for your quick reply!

 this is my properties pane.

I have tried /home/gjefferson/Desktop/FinalVTE...

I have tried/MacintoshHD/gjefferson/Desktop/FinalVTE...

I have tried the path inclusive of Users as well

I have tried the path with space between Macintosh HD as well.

I am stumped. Any other suggestions? Thank you in advance!

---