Separate positive and negative values into their own variables

nayab_shaik — Wed, 29 May 2019 16:26:11 GMT

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;

Re: sas

Oligolas — Wed, 29 May 2019 13:04:21 GMT

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