proc export to local csv

[nimmo_t]

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;

[Kurt_Bremser · Accepted solution]

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.

[nimmo_t]

thanks, totally makes sense!

was doing my head in.