topic Re: Duplicate row according to a variable in SAS Programming

Duplicate row according to a variable

John4 — Tue, 25 Apr 2017 13:09:09 GMT

I have a large data set like this :

NAME   MONEY   NB NUMBER
John        300       1         4
Max         250       2         5
Alex         657       1         3
Matt        1520      2         2

For NB = 2, I want to divide NB by 2 , divide MONEY by NUMBER and also keeping observations for NB = 1. I mean how get this :

NAME   MONEY   NB
John        300       1
Max         50       1

Max         50       1
Alex         657       1
Matt        760       1

Matt 760 1

Re: Duplicate row according to a variable

Kurt_Bremser — Tue, 25 Apr 2017 13:20:43 GMT

data want;
set have;
if nb = 2
then do;
  money = money / number;
  nb = nb / 2;
  output;
end;
output;
drop number;
run;

Re: Duplicate row according to a variable

PeterClemmensen — Tue, 25 Apr 2017 13:21:46 GMT

What if NB = 3 or higher, is that possible?

Re: Duplicate row according to a variable

John4 — Tue, 25 Apr 2017 13:31:08 GMT

In my data set, NB is only equals to 1 or 2

Re: Duplicate row according to a variable

Kurt_Bremser — Tue, 25 Apr 2017 13:32:26 GMT

You can replace the

nb = nb / 2;

in my code with

nb = 1;

as there can never be a different outcome.