topic Re: how to change negative value to positive in SAS Programming

how to change negative value to positive

harrylui — Mon, 02 Mar 2020 11:09:26 GMT

good day,

if i got the data like below. what can i do to remove negative value.

number

100

-100

200

-200

thanks in advance

harry

Re: how to change negative value to positive

PeterClemmensen — Mon, 02 Mar 2020 11:14:08 GMT

There is a difference between changing negative values to positive and removing negative values. I think you want the first, as indicated in your subject.

data have;
input number;
datalines;
100
-100
200
-200
;

data want;
    set have;
    number = abs(number);
run;

Re: how to change negative value to positive

Stephanvd — Mon, 02 Mar 2020 13:52:02 GMT

data have;
input number;
datalines;
100
-100
200
-200
;

data want;
    set have;
    where number >= 0;
run;

Re: how to change negative value to positive

harrylui — Tue, 03 Mar 2020 01:55:56 GMT

thank you all!