Copy excel file from network drive to UNIX location

nishant77goel — Mon, 21 Sep 2020 10:59:47 GMT

I was able to import file using the IMPORT wizard in SAS EG by using the network location directly. Now since we have to automate this process we want to define network drive in our SAS Code instead of using Import wizard.

Network location is like - "\\Un03pn\as_shared\PS\Req\N&G\"

Unix Location - "/com/csg/prdb/nonp/code/auto/sas/"

So ask is to either copy file from network location to Unix location and use it in SAS program

or directly copy file from network location in SAS code so that the code can be automated without manual intervention.

Thanks for any kind of help in advance!

Regards,

Nishant

Re: Copy excel file from network drive to UNIX location

Kurt_Bremser — Mon, 21 Sep 2020 11:09:21 GMT

Either have the UNC path mounted on your UNIX server, or use an external sftp if the network share server is also accessible through SSH.

topic Re: Copy excel file from network drive to UNIX location in SAS Programming

Copy excel file from network drive to UNIX location

Re: Copy excel file from network drive to UNIX location