Hi Kurt, Thank you very much. I do understand what you mean by 8byte and so as IEEE754. Been there done that too. Just wanted to achieve exactly what I wrote with minimum code. Mine logic is as follows. I think the approach is exactly equal but bit of code required so may wanted to have better answer from someone already been through same issues. pibbed it to 24bit (filled with zeros in front) by using do while and decimaling it by 8 bits each. It's actually decoded data from major Crypt blockchain and now so many bytes of hexadecimals everywhere. Found tough even for SAS or other DB experts to handle it. length dum_s $24.;
dum_s=substr(s_value,3);
do while(length(dum_s)<24);
dum_s="0"||dum_s;
end;
dum_dec1=input(substr(dum_s,1,8),hex8.);
dum_dec2=input(substr(dum_s,9,8),hex8.);
dum_dec3=input(substr(dum_s,17,8),hex8.);
dum1=dum_dec1*16**16;
dum2=dum_dec2*16**8;
dum3=dum_dec3*16**0;
value_wei=sum(dum1,dum2,dum3);
value_ether=value_wei/(10**18);
... View more