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,
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.