topic Re: How to separate positive and negative values in SAS ??? in SAS Programming

How to separate positive and negative values in SAS ???

Mohan_Reddy — Thu, 27 Feb 2020 10:26:29 GMT

I have dataset like below....



data ds;

input id amt;

datalines;

1 40

3 20

4 -10

5 -30

2 50

6 -20

;

run;


Through this dataset i want to create output dataset have two new variables and one variable contains positive values only and another variable have negative values only...

If anyone knows please write a programme ....

Re: How to separate positive and negative values in SAS ???

PeterClemmensen — Thu, 27 Feb 2020 10:30:04 GMT

Do like this

data ds;
input id amt;
datalines;
1 40
3 20
4 -10
5 -30
2 50
6 -20
;
run;

data want;
    set ds;
    if amt >= 0 then pos=amt;
    else             neg=amt;
run;

Result:

id  amt  pos  neg 
1   40   40   . 
3   20   20   . 
4   -10  .    -10 
5   -30  .    -30 
2   50   50   . 
6   -20  .    -20

Re: How to separate positive and negative values in SAS ???

Mohan_Reddy — Thu, 27 Feb 2020 10:30:54 GMT

But in that new variables blank place we want zero's please modify that programme

Re: How to separate positive and negative values in SAS ???

PeterClemmensen — Thu, 27 Feb 2020 10:32:33 GMT

data want;
    set ds;
    pos=0; neg=0;
    if amt >= 0 then pos=amt;
    else             neg=amt;
run;