topic proc export to local csv in New SAS User

proc export to local csv

nimmo_t — Fri, 23 Nov 2018 13:40:13 GMT

I am getting an error exporting to csv from sas 9.4 using pc file server.

ERROR: Insufficient authorization to access /sas/lev1/config/Lev1/SASApp/

I know I have Insufficient authorization because I can export to the same location as an xlsx, both codes below.

I don't get how one code works and the other doesn't.

proc export data=work.flowresults

outfile="\\xxxxxxxxxxx_yyyyy.co.uk\xxxshare$\Service Delivery\test.csv"

dbms=csv replace ;

SERVER="aaa.zzz.corp";

SERVERUSER="xxx" ;

SERVERPASS="yyy";

run;

proc export data=work.flowresults

outfile="\\xxxxxxxxxxx_yyyyy.co.uk\xxxshare$\Service Delivery\test.xlsx"

dbms=excelcs replace ;

SERVER="aaa.zzz.corp";

SERVERUSER="xxx" ;

SERVERPASS="yyy";

run;

Re: proc export to local csv

Kurt_Bremser — Fri, 23 Nov 2018 13:54:00 GMT

excelcs is a DBMS value that implies the use of a PC Files Server; csv OTOH will always write to a local file. Therefore you get syntax errors for the unexpected statements (server, serveruser,serverpass), which are also ignored.

The code then tries to write the local file to the current working directory of the SAS process, where you (rightfully) do not have write permission, as it lies in the SAS configuration tree.

The PC Files Server supports two file formats, MS Access and MS Excel.

For automatically writing to remote locations that can't be accessed via a network share, use filename ftp or filename sftp. With a network share, just use the mountpoint as the start of your path.

Re: proc export to local csv

nimmo_t — Fri, 23 Nov 2018 13:58:21 GMT

thanks, totally makes sense!

was doing my head in.