topic Re: SAS sql, how to use a newly created variable within the same sql in SAS Programming

SAS sql, how to use a newly created variable within the same sql

HappySASUE — Mon, 11 Feb 2019 14:28:23 GMT

This is a partial code of the one I am working on. the purpose is to change "-0.0" or "-0" to "0". I used "case" to create a new variable "New_min" and apply it to the next new variable "m". but I failed, can anyone tell me how to do it ? Thanks. The SAS version I am working on is 9.4.

proc sql noprint;
create table data2 as
select avisitn,

case
when abs(var_min) le 0.0000001 or var_min = -0 then 0
when var_min = . then .
else strip(put( var_min, 10.2 )) end as new_min,

strip(put(round(new_min,0.01),best.))||', '|| strip(put(round(_max,0.01),best.)) end as m

from data1;
quit;

Re: SAS sql, how to use a newly created variable within the same sql

tomrvincent — Mon, 11 Feb 2019 14:33:30 GMT

put 'calculated' in front of new_min:

strip(put(round(calculated new_min,0.01),best.))||', '|| strip(put(round(_max,0.01),best.)) end as m

http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/viewer.htm#a002294533.htm

Re: SAS sql, how to use a newly created variable within the same sql

PGStats — Mon, 11 Feb 2019 16:16:53 GMT

You could simplify to:

proc sql;
create table data2 as
select 
    avisitn,
    catx(", ", put(fuzz(var_min), 10.2), put(_max, 10.2)) as m
from data1;
quit;

Re: SAS sql, how to use a newly created variable within the same sql

HappySASUE — Mon, 11 Feb 2019 16:35:59 GMT

Thank you very much! it works.

Re: SAS sql, how to use a newly created variable within the same sql

HappySASUE — Mon, 11 Feb 2019 16:43:13 GMT

Thank you!