Dear,
I need help in my sql code. Some one helped the code. It worked but i have one more condition that i need to add.
I am getting output i need for all where "var" in a,b,c,d,e,f.
But var=g where i included a " when value lt 1 then 0" Please suggest. Thank you
Output needed for var =g
var value prec
g 0.5 0
g 10 0
output getting
var value prec
g 0.5 0
g 10 1
data have;
input var $ value;
datalines;
a 100.01
a 110.003
a 100
b 1.1
b 2
c 5.000002
c 6.01
c 4
d 2
d 5
d 1120
e .
e 100
e 10.02
f .
f 10
g 0.5
g 10
;
proc sql;
create table want as
select
*,
case when value =. then .
when value lt 1 then 0
else max(lengthn(scan(put(value, best32.), 2, "."))) end as prec
from have
group by var;
quit;
... View more