Can we create new variable based on existing column using Proc SQL ?

Stalk — Mon, 09 Aug 2021 02:36:36 GMT

I would like to create new field called Threshold based on the existing Test field. Is it possible to combine 2 code below with out an additional data step?

if test ="NP" then Threshold="> 14.80 = POS"
else if test="RB" then Threshold="> 14.64 = POS"
else if test="SP" then Threshold="> 19.66 = POS"

proc sql;
create table sample_final as
select sample, test, conc_calculated format=7.2, count(N) as Total_counts,
"" as Threshold,
from sample_calcs
group by sample, test, conc_calculated, Total_counts ;
quit;

Thank you

Re: Can we create new variable based on existing column using Proc SQL ?

Patrick — Mon, 09 Aug 2021 02:39:09 GMT

You can use a SQL CASE expression: https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/sqlproc/n0a85s0ijz65irn1h3jtariooea5.htm

Alternatively create a SAS format and use this format in your SQL to create the new variable. ...or don't even create the variable and just apply the format permanently to variable test.

topic Re: Can we create new variable based on existing column using Proc SQL ? in SAS Programming

Can we create new variable based on existing column using Proc SQL ?

Re: Can we create new variable based on existing column using Proc SQL ?