topic Re: How do I separate negative and positive values and create 2 more variables containing those valu in SAS Data Science

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

Mounika2 — Sun, 09 Jun 2019 15:49:59 GMT

Using data step

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

novinosrin — Sun, 09 Jun 2019 15:59:30 GMT

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;