Solved: How do I separate negative and positive values and create 2 more varia... - SAS Support Communities

🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.

Calcite | Level 5

Calcite | Level 5

How do I separate negative and positive values and create 2 more variables containing those values

Posted 06-09-2019 11:49 AM (468 views)

Using data step

Data is;
Input if amt;
Datalines;
40
20
-10
-30
50
-20
Run;

1 ACCEPTED SOLUTION

Accepted Solutions

Tourmaline | Level 20

Tourmaline | Level 20

Re: How do I separate negative and positive values and create 2 more variables containing those valu

Posted 06-09-2019 11:59 AM (461 views) | In reply to Mounika2

Data is;
Input  amt;
Datalines;
40
20
-10
-30
50
-20
0
;
Run;

data want;
set is;
if sign(amt)=-1 then neg_ve=amt;
else p_ve=amt;
run;

View solution in original post

1 REPLY 1

Tourmaline | Level 20

Tourmaline | Level 20

Re: How do I separate negative and positive values and create 2 more variables containing those valu

Posted 06-09-2019 11:59 AM (462 views) | In reply to Mounika2

Data is;
Input  amt;
Datalines;
40
20
-10
-30
50
-20
0
;
Run;

data want;
set is;
if sign(amt)=-1 then neg_ve=amt;
else p_ve=amt;
run;