topic Re: Cannot create Library when using Studio and Virtual Box in SAS Studio

Cannot create Library when using Studio and Virtual Box

mcgannmary — Thu, 21 Mar 2019 17:31:03 GMT

I am new to SAS and using the free e-learning program. I'm on the first step of creating a library and the code is correct: "libname pg1 "C:\Program Files\SASUniversityEdition\myfolders\data";

I keep getting this message and the library is not created,

NOTE: Library PG1 does not exist. 74

I'm running SAS through Virtual Box. Might that have something to do with the inability to create the library? How can I create libraries using Virtual Box, if that is the problem

Thanks in advance for any help!!

Re: Cannot create Library when using Studio and Virtual Box

BrianGaines — Thu, 21 Mar 2019 17:54:58 GMT

@mcgannmary,

Try to change the code to:

libname pg1 '/folders/myfolders/data';

VirtualBox is unable to see your entire C drive, as it is connected only to C:\Program Files\SASUniversityEdition\myfolders\, so instead you have to point it to the myfolders directory using /folders/myfolders/.

Did that fix the problem?

-Brian

Re: Cannot create Library when using Studio and Virtual Box

mcgannmary — Thu, 21 Mar 2019 17:59:03 GMT

Hi Brian,

Thanks for your speedy reply!

I ran the code you provided. Here are the notes...

73 libname pg1 '/folders/myfolders/data";

75 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

76 ODS HTML CLOSE;

77 &GRAPHTERM; ;*';

NOTE: Library PG1 does not exist.

77 ! *";*/;RUN;QUIT;

78 QUIT;RUN;

79 ODS HTML5 (ID=WEB) CLOSE;

81 ODS RTF (ID=WEB) CLOSE;

82 ODS PDF (ID=WEB) CLOSE;

NOTE: ODS PDF(WEB) printed no output.

(This sometimes results from failing to place a RUN statement before the ODS PDF(WEB) CLOSE statement.)

83 FILENAME _GSFNAME;

NOTE: Fileref _GSFNAME has been deassigned.

84 DATA _NULL_;

85 RUN;

Re: Cannot create Library when using Studio and Virtual Box

mcgannmary — Thu, 21 Mar 2019 18:03:40 GMT

Whoops...I see that a single quote and double quote were used, so I corrected that. I still get the same "does not exist" note.

Re: Cannot create Library when using Studio and Virtual Box

Quanshuo — Thu, 21 Mar 2019 18:28:55 GMT

I have the same issue when use virtual machine

Re: Cannot create Library when using Studio and Virtual Box

jennifert — Thu, 21 Mar 2019 18:52:22 GMT

Hi @mcgannmary.

That libname statement should be correct. Can you verify that you have created your shared folder correctly?

You can find information about creating a shared folder here:

How do I create a shared folder in VirtualBox?

Hope that helps!

thanks,

Jennifer

Re: Cannot create Library when using Studio and Virtual Box

Quanshuo — Thu, 21 Mar 2019 18:58:10 GMT

Hello Jennifer,

My folders create correctly, but still has this issue.

Thanks,

Quanshuo

Re: Cannot create Library when using Studio and Virtual Box

BrianGaines — Thu, 21 Mar 2019 19:46:39 GMT

@Quanshuo and @mcgannmary,

When you access the SAS® University Edition: Information Center (http://localhost:10080), are there any notifications in the lower left corner?

I just removed "myfolders" as a shared folder for the virtual machine. After doing that, there is a notification in the Information Center that alerts me of this:

Now, if I go to SAS Studio and run the libname statement code:

libname pg1 '/folders/myfolders/data';

then I also get "NOTE: Library PG1 does not exist." in the log.

Once I add myfolders as a shared folder for the virtual machine again, then the code works again. So like @jennifert suggested, I would verify that the shared folder was created correctly.

Please let us know if you are still having problems.

-Brian

Re: Cannot create Library when using Studio and Virtual Box

Quanshuo — Thu, 21 Mar 2019 19:58:15 GMT

I do have the folder and with no notifications.

Thank you for your quick replies.

Quanshuo

Re: Cannot create Library when using Studio and Virtual Box

ballardw — Thu, 21 Mar 2019 20:03:36 GMT

The virtual box runs in a Linux environment which is case sensitive.

Your code:

libname pg1 '/folders/myfolders/data";

Your picture appears to use "My Folders" , both capital letters and a space. So the spelling is incorrect.

I would suggest verifying that you create and use a /myfolders shared folder definition.

Re: Cannot create Library when using Studio and Virtual Box

Quanshuo — Thu, 21 Mar 2019 20:08:22 GMT

I would like to edit the folder's name but actually, I could build library, the problem is I could not find the lib when I restart.

But I will try that once I finish my HW.

Thank you again.

Re: Cannot create Library when using Studio and Virtual Box

BrianGaines — Thu, 21 Mar 2019 20:17:09 GMT

@Quanshuo,

Thanks for the info. Libraries are not automatically re-created when SAS Studio initializes again unless there are libname statements in your Autoexec file.

To view your autoexec file, click on the "More application options" icon in the upper-right corner:

which opens the Autoexec file:

Do you have any code in the autoexec file?

-Brian

Re: Cannot create Library when using Studio and Virtual Box

Quanshuo — Thu, 21 Mar 2019 20:22:22 GMT

Hello Brian,

I do not have any SAS statements to run when the application starts.

Best regards,

Quanshuo

Re: Cannot create Library when using Studio and Virtual Box

BrianGaines — Thu, 21 Mar 2019 20:24:33 GMT

@Quanshuo,

If that is the case, then the library will not be automatically created each time you open SAS Studio. So that is why the creation of the library worked the first time, but then it was not there in subsequent sessions.

-Brian

Re: Cannot create Library when using Studio and Virtual Box

Quanshuo — Thu, 21 Mar 2019 20:29:22 GMT

I got you.

Thank you again, Brian, I will try the solution about "

Pre-assigning Libraries in an Autoexec File
"

Best regards,

Quanshuo

Re: Cannot create Library when using Studio and Virtual Box

Quanshuo — Thu, 21 Mar 2019 21:00:00 GMT

Hello Brian,

Could not figure out how to do 'pre-assigning a library' in the virtual machine.

Do yo have any idea?

Thank you,

Quanshuo

Re: Cannot create Library when using Studio and Virtual Box

BrianGaines — Thu, 21 Mar 2019 21:03:53 GMT

@Quanshuo,

What is the libname statement code that you are using to create the library? Is it

libname pg1 '/folders/myfolders/data';

or something else?

-Brian

Re: Cannot create Library when using Studio and Virtual Box

Quanshuo — Thu, 21 Mar 2019 21:06:22 GMT

Hello Brian,

It is: LIBNAME score "/folders/myfolders";

Thanks,

Quanshuo

Re: Cannot create Library when using Studio and Virtual Box

BrianGaines — Thu, 21 Mar 2019 21:13:46 GMT

@Quanshuo,

I see, thank you. To add it to the Autoexec file, you simply open the Autoexec file and then paste that code in there.

First, access the Autoexec file as described in my previous post in this thread. Then paste the

LIBNAME score "/folders/myfolders";

code in there, so it should look like:

Next, hit save (in general it can be helpful to hit Run to make sure everything runs correctly). Now, that statement will be executed each time you open SAS Studio, meaning the score library will automatically be created.

Did that work?

-Brian

Re: Cannot create Library when using Studio and Virtual Box

Quanshuo — Thu, 21 Mar 2019 21:16:47 GMT

Perfect!!

Thank you, Brian.

Quanshuo