Specifying all data sets within a session

[FatCaptain]

My server is being rebooted shortly.

I'm trying to dump all of the data sets from the server work directory onto my pc so I can upload them again when the servers back online.

The code I'm trying to run is as follows;

RSUBMIT ;



LIBNAME drive 'C:\temp\sessiondump';



PROC COPY IN=SASCATCA OUT=drive ;

SELECT _ALL_ ;

RUN ;



ENDRSUBMIT ;

This code works if I individually list all of the datasets in the SELECT statement.

As the session has a few hundered data sets, I'm wanting to specify the entire contents using a single reference.

My first thought was _ALL_ but this isn't working.

Any ideas?

Any help with this would be appreciated.

Cheers,

Fat Captain.

[SPR]

Hello,

It is possible to create a list of tables from the work library:
[pre]
proc SQL noprint;
select memname into :tablst separated by " "
from sashelp.vmember
where libname="WORK"
;quit;
[/pre]
and then use it in proc COPY:
[pre]
select &tablst;
[/pre]

SPR

[ArtC]

If you do not use the SELECT statement the default is everything of the given memtype.

[Ksharp]

Hi. Art Carpenter is right. Remember SAS syntax is very flexible.
To incorporate Arc's view,you can use modify input or list input ,Such as

[pre]

select a: b: art1-art100;
[/pre]

a: stand for any name of data set which start with alphabetical ' a ';


Ksharp

[Florent]

Hi,

You could also create a remote library pointing the WORK library of your server, and then use the datasets procedure in order to move all datasets from that remote library to a local library.

Code is to be executed on the local session (outside of the RSUBMIT/ENDRSUBMIT) and before signing off your connection with the server.

libname rwork server= slibref=work;

proc datasets nolist;
copy in=rwork out=work;
quit;
run;

I hope it helps.

Regards,
Florent

[FatCaptain]

Thank you all for your help.

You've got to love SAS for the flexability it offers.

Cheers,

Fat Captain.