topic Re: SAS on Demand on Mac in New SAS User

SAS on Demand on Mac

Noudjoum — Wed, 04 Mar 2020 19:22:49 GMT

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.

Re: SAS on Demand on Mac

Reeza — Wed, 04 Mar 2020 19:33:01 GMT

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.

Re: SAS on Demand on Mac

Cynthia_sas — Wed, 04 Mar 2020 21:05:38 GMT

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

Re: SAS on Demand on Mac

Noudjoum — Thu, 05 Mar 2020 00:33:42 GMT

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!

Re: SAS on Demand on Mac

Reeza — Thu, 05 Mar 2020 02:03:57 GMT

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

Re: SAS on Demand on Mac

Reeza — Thu, 05 Mar 2020 02:16:04 GMT

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.

Re: SAS on Demand on Mac

Noudjoum — Fri, 06 Mar 2020 21:34:40 GMT

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.

Re: SAS on Demand on Mac

Noudjoum — Fri, 06 Mar 2020 21:41:37 GMT

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

Thanks for your help everyone!!!

Re: SAS on Demand on Mac

gjefferson — Fri, 24 Apr 2020 16:56:56 GMT

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;

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.

Re: SAS on Demand on Mac

Reeza — Fri, 24 Apr 2020 17:05:34 GMT

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.

Re: SAS on Demand on Mac

gjefferson — Fri, 24 Apr 2020 17:17:36 GMT

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.

Re: SAS on Demand on Mac

gjefferson — Fri, 24 Apr 2020 17:22:57 GMT

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!

Re: SAS on Demand on Mac

Reeza — Fri, 24 Apr 2020 17:26:44 GMT

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!

Re: SAS on Demand on Mac

gjefferson — Fri, 24 Apr 2020 17:31:40 GMT

Great point re: the cloud!

So that was the easiest method I had presumed, however, when I try to drag the file for uploading I receive a message that only sas files are uploaded in this manner.

Do you know how to save my excel file as a sas file?

Re: SAS on Demand on Mac

Reeza — Fri, 24 Apr 2020 17:33:33 GMT

That's not correct so either you did something wrong or the system is wrong somehow. Please show some screenshots of what you're doing.

You should just be clicking upload, and then selecting the file. Once the file has been uploaded, you'll then have to 'import' the data using a task or code to create a SAS data set.

Are you following one of the online courses? They have their own set up instructions as well.

Re: SAS on Demand on Mac

gjefferson — Fri, 24 Apr 2020 17:41:04 GMT

I appreciate your time and will find a course.

Re: SAS on Demand on Mac

Reeza — Fri, 24 Apr 2020 17:42:54 GMT

Yeah, you're trying to UPLOAD not IMPORT the data - two different definitions here.

Look at the image you posted and the top right hand corner. See the up/down arrows there? Use that to upload your files, then apply the import task to the file you upload.

Re: SAS on Demand on Mac

Reeza — Fri, 24 Apr 2020 17:43:57 GMT

You may want to click or expand your VTEproject folder and then click the up arrow to upload the file to the folder.

Re: SAS on Demand on Mac

gjefferson — Fri, 24 Apr 2020 18:06:17 GMT

I have made progress. I can click on the "choose file" to upload, I can click the file from my Desktop list (not captured) and then SAS tells me in a pop up "no file selected" when I click "upload" in the pic.

Re: SAS on Demand on Mac

Reeza — Fri, 24 Apr 2020 19:35:26 GMT

Show those screenshots. It works for me in SAS On Demand, if you continue to have issues beyond this you may want to contact SAS tech support or follow one of the FREE courses video instructions.