02-07-2018 07:46 AM
I am working on SAS 9.4 and it is on Unix server now when I want to export a SAS dataset in CSV on my local machine, I get an error.
I know it is because I am trying to transfer it fromUnix... but do we have an alternative to transfer it to window(by code not by file export option)
proc export data=ABC dbms=csv
ERROR: Insufficient authorization to access /sas/common/config/Lev1/SASApp/\\homedrivestmp\homedisk1\emar646\Desktop\Forecast\New
I also tried
%ds2csv (data=abc, runmode=b, csvfile=\\homedrivestmp\homedisk1\emar646\Desktop\Forecast\New folder\retail.csv);
its not working and just opening the sas dateset and not transferring anything
02-07-2018 07:52 AM
You are using the wrong (Windows-style) pathname on UNIX. Ask your UNIX admins how to access the share from the SAS server.
Hint: UNIX uses the forward slash as a separator of directories.
02-07-2018 09:19 AM
02-07-2018 11:17 AM
WinSCP is free as in beer (and free as in speech).
If your customer wants automated transfer, they have to provide a means for that. Either a shared resource or some kind of ssh-based file transfer.