topic Re: Moving SAS datasets in SAS Programming

Moving SAS datasets

sg_kr — Fri, 19 Apr 2019 15:03:35 GMT

HI,

i want to move SAS datasets from server to local drive and to do it all together,not one by one.

is there any way to do this, other than macro?

please help.

thanks,

goutham

Re: Moving SAS datasets

PaigeMiller — Fri, 19 Apr 2019 15:17:07 GMT

You can use drag and drop (or cut and paste) in your operating system

There's also PROC COPY which will copy (not move) datasets to a new location.

Re: Moving SAS datasets

r_behata — Fri, 19 Apr 2019 15:22:35 GMT

Are you trying to copy sas datasets from Linux (Server) to Windows (Local) ? Try WinScp or Sftp. If it is windows to Windows copy you can map the local drive to your server or do Sftp.

Linux to Windows transfer would need additional steps to make the file usable.

Re: Moving SAS datasets

Patrick — Sat, 20 Apr 2019 02:06:19 GMT

Does that mean you also have a local SAS installed? If so do you also have SAS/Connect installed on the local and the remote SAS instance?

If you don't have a local SAS instance: Why would you want to move the SAS files?

Re: Moving SAS datasets

sg_kr — Thu, 25 Apr 2019 12:12:30 GMT

im using WINSCP, but its consuming lot of time .

any other way to move?

Re: Moving SAS datasets

sg_kr — Thu, 25 Apr 2019 12:24:47 GMT

when i use the proc datasets to copy the datasets from SAS server to local dirve.

im facing the below error.

it showing SAS server libname is re assigned.

193 rsubmit;
NOTE: Remote submit to METRO commencing.
537 Libname FLEX_INT '/data/u01/export/home/customer/BAT/TDB/FLEX_INT';
ERROR: Unable to clear or re-assign the library FLEX_INT because it is still in use.
ERROR: Error in the LIBNAME statement.
NOTE: Remote submit to METRO complete.

Re: Moving SAS datasets

Patrick — Fri, 26 Apr 2019 01:46:46 GMT

@sg_kr

Looks like you've got SAS/Connect licensed. If so then use Proc Download as this will also ensure that the target SAS file will be in the encoding of your target SAS environment plus will also include things like indexes and constraints if you chose to do so.

https://go.documentation.sas.com/?docsetId=connref&docsetTarget=n01xxs4f7yb4cln188odwmewp98x.htm&docsetVersion=9.4&locale=en