data _null_;
set Work.Sample ;
file 'C:\Users\John\Desktop\Sample.csv' dsd ;
put (_all_) (+0);
run;
ERROR: Insufficient authorization to access /sas/config/compute/SASApp/C:\Users\John\Desktop\Sample.csv.
Why would export default to server, what am I missing here to set the export to desktop ?
The Query Builder in EG does not export anything, it creates datasets through pure SQL code.
The Export wizard sends code to the server that writes a file in WORK, and then EG copies the file to your desktop for further processing (e.g. conversion to Excel).
So you either overrun your WORK quota on the server, or run out of space on your desktop. Consult with your SAS administrators if you have a disk full issue in your WORK.
Time is not an issue, as EG does exactly what I told you before: create a file on the server, then download it.
Setting up a network share between server and desktop will make this much easier, and for that you also need your SAS/server admins.
Your SAS session runs on a UNIX server, so you have to use UNIX filename syntax and create your files in a location where you have write permission; I suggest to use your home directory ($HOME).
Afterwards, use the download facility in SAS Studio or the Copy Files task of Enterprise Guide to transfer the file to your PC.
Talk to your SAS administrator about creating a server folder share that is accessible from both the SAS server and your PC, for example via Windows Explorer. Then you can write to this folder using any SAS code and access any data there with desktop apps. Its usually not a good idea to store company on your PC hard drive for security reasons.
The Query Builder in EG does not export anything, it creates datasets through pure SQL code.
The Export wizard sends code to the server that writes a file in WORK, and then EG copies the file to your desktop for further processing (e.g. conversion to Excel).
So you either overrun your WORK quota on the server, or run out of space on your desktop. Consult with your SAS administrators if you have a disk full issue in your WORK.
Time is not an issue, as EG does exactly what I told you before: create a file on the server, then download it.
Setting up a network share between server and desktop will make this much easier, and for that you also need your SAS/server admins.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.