a******6 发帖数: 78 | 1 *********************************************
proc sql;
create table ratio_anl as
select a.day, a.gel, a.cond as cond1, b.cond as cond2,
a.cond || ':' || b.cond as comp,
case b.cond when 'A' then 0.25
when 'B' then 0.5
when 'C' then 1
when 'D' then 1.5
when 'E' then 2
end as pr_ratio,
a.sas_avg as sas_avg1, a.sas_sd as sas_sd1,
b.sas_avg as sas_avg2, b.sas_sd as sas_sd2,
a.ratio, ( a.sas_sd**2 + (a.ratio*b. | l***a 发帖数: 12410 | 2 imagine you make the ratio data set a duplicate copy, say named ratio1. then
re-write code as from ratio as a, ratio1 as b
【在 a******6 的大作中提到】![](/moin_static193/solenoid/img/up.png) : ********************************************* : proc sql; : create table ratio_anl as : select a.day, a.gel, a.cond as cond1, b.cond as cond2, : a.cond || ':' || b.cond as comp, : case b.cond when 'A' then 0.25 : when 'B' then 0.5 : when 'C' then 1 : when 'D' then 1.5 : when 'E' then 2
| a******6 发帖数: 78 | 3 I c
Thanks a lot~~
then
【在 l***a 的大作中提到】![](/moin_static193/solenoid/img/up.png) : imagine you make the ratio data set a duplicate copy, say named ratio1. then : re-write code as from ratio as a, ratio1 as b
|
|