Separate positive and negative values into their own variables

[nayab_shaik]

Hi Team,

using below data set create 2 more variable in that one variable contain positive values another one contain negative values

data ds1;

input id amt;

cards;

1 40

3 20

4 -10

5 -30

2 50

6 -20

;

run; 

[Oligolas · Accepted solution]

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