Hi everyone,
I need to change a number like this 1105636746057493629 to hex and then back to a string that's looks like a hex e.g. 5902c33b625600 .
This macro works but will only do one at a time, and I need to do thousands of them.
%macro dec2hex(dec); data _null_; msg=cat("&dec = #", put(&dec, hex14.)); put msg; run;
%dec2hex(1105636746057493629);
So I tried this to do them in bulk with this but I get results like 4.7909991E15
data add_new_column; set work.Full_Report; connid2 = input(Call_ID, hex14.); run;
If you're not too busy could you please give some advice?
... View more