proc sql table update

alter and update


proc sql;
   alter table one
   add rawP num label='P value'
   add estimation num label ='Effect'

;

quit;

proc sql;
update one
set
rawP = (select ProbF from Pout s where s.effect= "Trt"),
p3 = (select ProbF from Pout s where
s.effect contains "Trt" and s.effect contains 'visit' )
where  one.poly = "rs1" and one.gene ="ABC";
quit;