1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44
|
data test_1;
set sashelp.class (keep=Age sex);
run;
data test_2;
set sashelp.class (keep=Age sex);
run;
data test_3;
set sashelp.class (keep=Age sex);
run;
proc sql;
create table list_tabs as select memname, scan(memname, -1,'_') as increment from sashelp.vtable where upcase(libname)='WORK'
and upcase(memname) like 'TEST%'
;
quit;
data _null_;
set list_tabs;
call execute (" proc sql; create table tab_" !!left(_n_) !! " as select sex,avg(age)as m_age_"!! increment !!" from "!! memname !! " group by sex;quit;"
);
run;
proc sql;
select memname into : tabs separated by " " from sashelp.vtable where upcase(libname)='WORK'
and upcase(memname) like 'TAB_%'
;
quit;
data final;
merge &tabs ;
by sex;
run;
proc delete data=&tabs;
;
run; |
Partager