topic exporting from unix environment to window environment in SAS Programming

exporting from unix environment to window environment

Deepankar — Wed, 07 Feb 2018 12:46:16 GMT

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)

code:

proc export data=ABC dbms=csv

outfile="\\homedrivestmp\homedisk1\emar646\Desktop\Forecast\New folder\NEW_ENROLLMENT.csv"

replace;

run;

error:

ERROR: Insufficient authorization to access /sas/common/config/Lev1/SASApp/\\homedrivestmp\homedisk1\emar646\Desktop\Forecast\New
folder\NEW_ENROLLMENT.csv.

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

Re: exporting from unix environment to window environment

Kurt_Bremser — Wed, 07 Feb 2018 12:52:58 GMT

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.

Re: exporting from unix environment to window environment

Deepankar — Wed, 07 Feb 2018 14:15:21 GMT

well, the error is, its not able to access the window location. people from here says, its not possible.

Re: exporting from unix environment to window environment

Kurt_Bremser — Wed, 07 Feb 2018 14:19:21 GMT

Store the file on the UNIX system and then use a tool like WinSCP to fetch it.

Re: exporting from unix environment to window environment

Deepankar — Wed, 07 Feb 2018 15:21:15 GMT

client wont buy a new software, we are limited to these resources only.

Re: exporting from unix environment to window environment

Kurt_Bremser — Wed, 07 Feb 2018 16:17:23 GMT

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.