最近工作忙sas比较多,新手,有很多问题不明白,请教各位神:
一段宏中有如下的代码:
proc sql;
create table f as
select count(id) as
g_1 from &survival_data. where &strata.=
1;
create table g as
select count(id) as
g_2 from &survival_data. where &strata.=
2;
quit;
data _null_;
set f;
call symput("
g_1",left(compress(trim(
g_1))));
run;
data _null_;
set g;
call symput("
g_2",left(compress(trim(
g_2))));
run;
这里&strata有两个组,生成两个数字g_1和g_2,有时候会有3个组,我还要再添加一个g_3,请问各位神,有没有什么方法可以自动根据strata生成相应的g_i数的?