topic Question about PROQ SQL calculated variables in SAS Programming

Question about PROQ SQL calculated variables

jmmedina25 — Fri, 26 Jul 2019 18:18:06 GMT

Is there any way to calculate a field in a select statement based on a calculated field in the same statement. Example:

Proq sql;

create table want as

select

input (var1, BEST26.) as var1_new,

input (var2, BEST26.) as var2_new,

sum(var1_new, var2_new) as sum_var,

from have

quit;

Re: Question about PROQ SQL calculated variables

novinosrin — Fri, 26 Jul 2019 18:26:37 GMT

would this work?

Proc sql;

create table want as

select 

input (var1, BEST26.) as var1_new,

input (var2, BEST26.) as var2_new,

sum(calculated var1_new, calculated var2_new) as sum_var,

from have

quit;

Re: Question about PROQ SQL calculated variables

jmmedina25 — Fri, 26 Jul 2019 18:32:57 GMT

It did work, thank you!