@tarheel13 It's not producing the desired results. You can execute and check
proc sql;
create table have
(id char(200),CRF char(200), value char(200));
insert into have
values('PLAP24MRT_MV','[INS]#MAX1','-956461.285475')
values('PLAP24MRT_MV', '[INS]#MAX2','-30254.271916');
quit;
proc sql;
create table have3 as
select distinct id, scan(CRF,1,'#') as CRF,
case when scan(CRF,-1,,'ka')="MIN" then strip(put(min(input(value,26.4)),26.4))
when scan(CRF,-1,,'ka')="MAX" then strip(put(max(input(value,26.4)),26.4))
when scan(CRF,-1,,'ka')="AVG" then strip(put(mean(input(value,26.4)),26.4))
when scan(CRF,-1,,'ka')="STD" then strip(put(std(input(value,26.4)),26.4))
else '' end as value
from have
group by id, CRF;
quit;
... View more
