topic Re: Specifying all data sets within a session in SAS Programming

Specifying all data sets within a session

FatCaptain — Thu, 18 Nov 2010 16:59:12 GMT

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.

Re: Specifying all data sets within a session

SPR — Thu, 18 Nov 2010 17:30:15 GMT

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

Re: Specifying all data sets within a session

ArtC — Thu, 18 Nov 2010 18:53:21 GMT

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

Re: Specifying all data sets within a session

Ksharp — Fri, 19 Nov 2010 03:20:24 GMT

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

Re: Specifying all data sets within a session

Florent — Fri, 19 Nov 2010 11:51:07 GMT

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

Re: Specifying all data sets within a session

FatCaptain — Fri, 19 Nov 2010 14:46:33 GMT

Thank you all for your help.

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

Cheers,

Fat Captain.