How do I get rid of the negative sing. -123490 I have and I want 123490.
amt = -123490;
I want amt1 = 123490 without the negative sign.
if numeric. use abs function
data want;
amt = -123490;
am1=abs(amt);
run;
Hello,
If you only want to get rid of the minus sign when you display results in reports but
without losing the information in the dataset, you can use a format as follows :
proc format;
value noneg other=[abs()];
run;
data have;
x=-1;
run;
proc print data=have;
format x noneg.;
run;
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.