topic Re: SAS Univ Edition Question - output / input Excel Spreadsheet in SAS Programming

SAS Univ Edition Question - output / input Excel Spreadsheet

BrentonCSmith — Tue, 14 Aug 2018 18:29:55 GMT

I have found some documentation on creating an Excel spreadsheet. I am running into an error because

ERROR: Insufficient authorization to access /opt/sasinside/SASConfig/Lev1/SASApp/C:\temp.csv.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: There were 1 observations read from the data set WORK.BREAKEVEN_RETURN.

NOTE: DATA statement used (Total process time):

I am trying to put the Excel spreadsheet on my PC.

proc export data= &Dataname
               outfile= "C:\temp.csv"
               dbms=csv replace;
run;

It seems that the system wants to create the file on the server rather than on my PC.

Any help would be appreciated....

Thanks,

Re: SAS Univ Edition Question - output / input Excel Spreadsheet

ballardw — Tue, 14 Aug 2018 19:24:51 GMT

The University Edition is limited to locations that the virtual environment it runs it can access. Since the virtual environment is a Linux system it does not understand Windows disks or paths. So it is trying to write to the current active location which is the program directory. I suspect you need to move to a destination file in /folders/myfolder/ or somewhere subordinate to that.

By the way CSV files are not spreadsheet files. They are text. It just happens that Excel can open and use the file format. Carefully.

Re: SAS Univ Edition Question - output / input Excel Spreadsheet

Reeza — Tue, 14 Aug 2018 19:47:39 GMT

In the installation process you created a folder called myfolders. You need to export your data there:

proc export data=sashelp.class outfile='/folders/myfolders/Temp.csv' dbms=csv replace; run;

The reason for this, is that SAS UE runs on a virtual machine on your computer and is connected similar to a network drive and that's the path necessary. You cannot use Windows path references.

If you want more folders you can create them similar to the way you did for the myfolders and access them via, where NAME is the designated folder name.

/folders/myshortcuts/NAME

@BrentonCSmith wrote:

I have found some documentation on creating an Excel spreadsheet. I am running into an error because

ERROR: Insufficient authorization to access /opt/sasinside/SASConfig/Lev1/SASApp/C:\temp.csv.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: There were 1 observations read from the data set WORK.BREAKEVEN_RETURN.

NOTE: DATA statement used (Total process time):
 
I am trying to put the Excel spreadsheet on my PC.

proc export data= &Dataname
               outfile= "C:\temp.csv"
               dbms=csv replace;
run;


It seems that the system wants to create the file on the server rather than on my PC.

Any help would be appreciated....

Thanks,