topic Access pc local folder from VM sas studio in SAS Studio

Access pc local folder from VM sas studio

jlc_11364 — Fri, 21 Feb 2020 23:38:27 GMT

I am new to sas studio, I was wondering how to import/export data/programs from/to my local pc folders in VM sas studio. This could be obvious to you, but please help.

Thanks-jc

Re: Access pc local folder from VM sas studio

BrianGaines — Fri, 21 Feb 2020 23:39:53 GMT

Hi @jlc_11364,

When you say VM SAS Studio, are you referring to SAS University Edition?

-Brian

Re: Access pc local folder from VM sas studio

BrianGaines — Fri, 21 Feb 2020 23:44:34 GMT

@jlc_11364,

Assuming that you are referring to SAS University Edition, you need to make sure to follow the installation steps to set up the "myfolders" folder on your local PC that will be linked to the virtual machine.

Please see the instructions and videos Step 1 and Step 3 of the installation overview.

If you still have issues, please post back here.

Thanks,

-Brian

Re: Access pc local folder from VM sas studio

jlc_11364 — Sun, 23 Feb 2020 04:33:59 GMT

Hi Brian,

Yes, it is the university edition.

Jianlin

Re: Access pc local folder from VM sas studio

jlc_11364 — Sun, 23 Feb 2020 04:38:36 GMT

I set up the myfolders in my local c drive during the installation. The question is where in the sas studio can I look up myfolders.

Please advise.

Thanks-Jianlin

Re: Access pc local folder from VM sas studio

BrianGaines — Sun, 23 Feb 2020 05:00:29 GMT

Hi @jlc_11364,

Look in the "Server Files and Folders" section of the navigation pane on the left. There is a "My Folders" folder that corresponds to the myfolders folder on your local PC:

Do you see this in SAS Studio?

Best,

-Brian

Re: Access pc local folder from VM sas studio

jlc_11364 — Sun, 23 Feb 2020 12:46:44 GMT

Yes, I got this now. Thanks for the help.

Jianlin

Re: Access pc local folder from VM sas studio

BrianGaines — Sun, 23 Feb 2020 13:08:31 GMT

@jlc_11364 (Jianlin),

No problem, I'm glad to help! And I'm glad that you figured it out.

-Brian

Re: Access pc local folder from VM sas studio

jlc_11364 — Sun, 23 Feb 2020 13:32:02 GMT

I got error when I try to establish the libname, see the log below. Did I specify the wrong path there?

Thanks-Jianlin

libname MYLIB "C:\Users\USWU56990\Documents\SASUniversityEdition\myfolders\proj1";

Re: Access pc local folder from VM sas studio

BrianGaines — Sun, 23 Feb 2020 14:11:17 GMT

@jlc_11364,

Yes, the VM cannot see the full myfolders path on your local PC. Instead, there is a special path to myfolders that is used within SAS University Edition: /folders/myfolders/

You can see this if you go to "Server Files and Folders" in the navigation pane on the left, right-click "My Folders" and then select "Properties."

So the LIBNAME statement would look like the following:

libname MYLIB "/folders/myfolders/proj1";

Did that work for you?

-Brian

Re: Access pc local folder from VM sas studio

jlc_11364 — Sun, 23 Feb 2020 15:20:13 GMT

it worked. Thanks a lot.

Re: Access pc local folder from VM sas studio

jlc_11364 — Sun, 23 Feb 2020 15:24:32 GMT

Actually, I am planning to play with a large dataset using the university edition. I wonder if there is a limitation on the data size with this edition. Please advise.

Jianlin

Re: Access pc local folder from VM sas studio

Tom — Sun, 23 Feb 2020 17:22:06 GMT

@jlc_11364 wrote:

Actually, I am planning to play with a large dataset using the university edition. I wonder if there is a limitation on the data size with this edition. Please advise.

Jianlin

There is no limit. But the virtual machine has limited memory and limited space in the WORK library.

Just make sure to write your datasets and large outputs to the folder that is mapped to your real disk and it should work fine. Only use WORK for small datasets.

Re: Access pc local folder from VM sas studio

jlc_11364 — Sun, 23 Feb 2020 17:57:25 GMT

Thanks Tom for the reply. I understand that the input and output files should be directed to the local folder. But if I have a need to run regression or large data sorting on the virtual machine, do you think it can not be handled?

Thanks-Jianlin

Re: Access pc local folder from VM sas studio

Tom — Sun, 23 Feb 2020 19:00:37 GMT

@jlc_11364 wrote:

Thanks Tom for the reply. I understand that the input and output files should be directed to the local folder. But if I have a need to run regression or large data sorting on the virtual machine, do you think it can not be handled?

Thanks-Jianlin

The amount of memory needed for regression is related to the dimension of the model, not the size of the dataset.

You cannot control the UTILLOC setting, so you might have to split the data into pieces and sort each piece separately and then re-combine.