Moving SAS datasets

[sg_kr]

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

[PaigeMiller]

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.

[sg_kr]

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.

[r_behata]

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.

[sg_kr]

im using WINSCP, but its consuming lot of time  .

any other way to move?

[Patrick]

@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&doc...

[Patrick]

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?