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;
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.