topic Re: creating library & exporting Data in SAS University Edition - Help in New SAS User

Re: creating library & exporting Data in SAS University Edition - Help

Sakshi_Maggu — Thu, 13 Feb 2020 17:41:25 GMT

I'm still getting the same problem. Not sure how to make a share drive in virtual machine as one is already build, which I built following the instructions provided.

Also, I'm getting an error while exporting the data as well:

ERROR: Insufficient authorization to access

/opt/sasinside/SASConfig/Lev1/SASApp/C:\Users\sakshi\SASUniversityEdition\myfolders\Cars_test.xls.

Below were my codes:

for Library :

LIBNAME Test2 'C:\Users\sakshi\SASUniversityEdition\myfolders';

For exporting data:

proc export data=cars1
outfile='C:\Users\sakshi\SASUniversityEdition\myfolders\Cars_test.xls'
Replace
dbms=xls;
run;

(cars1 is created in my work library)

Sakshi

Re: creating library & exporting Data in SAS University Edition - Help

Tom — Thu, 13 Feb 2020 17:49:38 GMT

If you are using SAS University Edition then when you did the installation you setup a connection in the Virtual Machine between the directory /folders/myfolders to some directory on your actual machine. So assuming that directory on your actual machine was C:\Users\sakshi\SASUniversityEdition\myfolders then your code needs to look like:

proc export data=cars1
  outfile='/folders/myfolders/Cars_test.xls'
  replace
  dbms=xls
;
run;

Re: creating library & exporting Data in SAS University Edition - Help

RandyMullis — Thu, 13 Feb 2020 18:14:56 GMT

Yes, @Sakshi_Maggu , the SAS University Edition virtual machine is Linux-based. Therefore, file and directory paths need to use the proper Linux syntax. You can always find the correct path by simply clicking on the folder on the left and choosing Properties. The location in the Properties can be copied and pasted into your code.