topic Re: Reg:First obs from all Datasets in a library in SAS Procedures

Reg:First obs from all Datasets in a library

sas_ — Wed, 21 Apr 2010 05:54:50 GMT

Hi

I am having a library names NEW in that i have 20 datasets like A,RB,CA,DQ,EO,TF,G,Jk,Ed,LO,PI,UI,TY,QW.....with variable names ex-Age id no name in all the above datasets
Now i want to create a new dataset a21 with all the first observarions from datasets names above in to new dataset a21.

Re: Reg:First obs from all Datasets in a library

Patrick — Wed, 21 Apr 2010 06:06:52 GMT

Syntax working for SAS9.2:

data a_1 a_2 a_3;
do i=1 to 5;
output;
end;
run;

data a_all;
set a_1 -a_3 (obs=1);
run;

Before SAS9.2 it would be:
set a_1(obs=1) a_2(obs=1).... ;

Message was edited by: Patrick

Re: Reg:First obs from all Datasets in a library

Peter_C — Wed, 21 Apr 2010 09:38:17 GMT

sas_

do you have SAS9.2 or which earlier release?

hth
PeterC.

Re: Reg:First obs from all Datasets in a library

sas_ — Wed, 21 Apr 2010 13:23:59 GMT

i am having sas 9.2 .

Re: Reg:First obs from all Datasets in a library

P_J — Thu, 29 Apr 2010 18:01:20 GMT

Please try something like this to see if it works, I'm using 9.1.3

proc sql;
select cats("NWK.",memname) into :dsn separated by " "
from sashelp.vstable
where libname ="NWK"
;
quit;

options obs=1;
data all;
set &dsn;
run;

%put &dsn=;

Re: Reg:First obs from all Datasets in a library

sas_ — Fri, 30 Apr 2010 05:22:28 GMT

Thqs it worked