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 的大作中提到】
: *********************************************
: 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 的大作中提到】
: 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
|
|
