topic Re: Proc Export defaulting to server in SAS Programming

Proc Export defaulting to server

PROCDATARUN — Tue, 30 Nov 2021 22:13:45 GMT

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 ?

Re: Proc Export defaulting to server

Kurt_Bremser — Tue, 30 Nov 2021 22:21:37 GMT

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.

Re: Proc Export defaulting to server

PROCDATARUN — Tue, 30 Nov 2021 22:50:53 GMT

Thanks @Kurt_Bremser

Am trying to export a large dataset to CSV which fails due to size when export step is used on EG query builder.
2 mill rows and 100 columns.

Export step on query builder does allow exporting to desktop.

How would you overcome this issue ?

Exporting to a unix location and then downloading adds more time.

Re: Proc Export defaulting to server

SASKiwi — Tue, 30 Nov 2021 23:14:55 GMT

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.

Re: Proc Export defaulting to server

Kurt_Bremser — Wed, 01 Dec 2021 06:18:30 GMT

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.