data test;
if total = -0 then R=0;
run;
This did not convert -0 to 0;
I tried this also
data test;
if total = 0 then R = abs(val0);
run;
Do you really have values that are –0?? I have never seen them. Why bother converting them, anyway?
But your code is off the mark.
How about this untested code:
data test;
set test;
if total= -0 then total=0;
run;
Paige Miller wrote:
Do you really have values that are –0?? I have never seen them. Why bother converting them, anyway?
But your code is off the mark.
How about this untested code:
data test;
set test;
if total= -0 then total=0;
run;
It's has to do with w.d format. I don't know if it is intentional or not but very small negative print as -0.
It's showing as -0, but is probably -0.000009 or something like that.
Try a round function or a floor or ceiling instead depending on what will work based on your other data points.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: