topic Re: set statement in SAS Programming

set statement

deleted_user — Sat, 20 Feb 2010 09:42:50 GMT

Dear All,

I'm having nearly 100 sas datasets with naming convention as sample1, sample2, sample3, etc...Variables are common in all the SAS datasets
how to combine all this ?

Re: set statement

Patrick — Sat, 20 Feb 2010 13:16:52 GMT

data all;
set sample1 - sample;
run;

or as data step view avoiding to duplicate data:

data all /view=all;
set sample1 - sample;
run;

Re: set statement

Peter_C — Sat, 20 Feb 2010 16:21:53 GMT

Patrick offers the best solution which is valid since SAS9.2. Before this release we needed to list each of the datasets on a set statement.
Another good feature of SET statement added in SAS9.2 is the option INDSNAME=.
This names a variable that indicates from which of the datasets on the statement the current observation has come.

PeterC

Re: set statement

sbb — Sat, 20 Feb 2010 18:59:37 GMT

Also, new with SAS 9.2, the SET statement can specify a file-prefix (stem), such as:

SET XXXYYY: ;

Very helpful with avoiding the need to code NODSNFERR when you are not sure how many "cycles" or "versions" of a given file are available to select.

Scott Barry
SBBWorks, Inc.

Re: set statement

Patrick — Sun, 21 Feb 2010 02:19:48 GMT

INDSNAME= !!!

Why didn't you tell me earlier! 🙂

It's only 2 weeks ago that I ended up doing some complicated coding because I missed this 9.2 enhancement to the set statement.

Thanks for this info Peter. That will come in very handy (also: I should now amend my code...)

Cheers
Patrick

Re: set statement

DanielSantos — Wed, 24 Feb 2010 09:38:11 GMT

Quite a lot of great and interesting new features, thanks for the info!

Since I'm still "stuck" at work with the 9.1.3, here's the alternative:
[pre]
proc sql noprint;
select catx('.',LIBNAME,MEMNAME) into: TABS separated by ' ' from DICTIONARY.TABLES
where LIBNAME='' and MEMNAME like '%';
quit;
%put &TABS;

data ALL;
set &TABS;
run;
[/pre]
Cheers from Portugal.

Daniel Santos @ www.cgd.pt