I have found some documentation on creating an Excel spreadsheet. I am running into an error because
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,
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,
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.
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,
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.