SAS Extrapolation

[Lopa2016]

ID   Good_Bad
734374  0
4834110 1

I want to extrapolate the 1's 12 times as 0s so that for every 0 I have 12 1s like this:

ID  Good_Bad
734374  0
4834110 1
4834110 1
4834110 1
4834110 1
4834110 1
4834110 1
4834110 1
4834110 1
4834110 1
4834110 1
4834110 1
4834110 1

& this has to be done using SAS. Can anyone help out?

Thanks in advance!!

[Kalind_Patel · Accepted solution]

Try this code:

data test;
input ID Good_Bad ;
infile datalines;
datalines;
734374  0
4834110 1
;
run;



data final(drop=i); 
  set test; 
  by Good_Bad;
  if Good_bad=0 then output;
  if Good_Bad=1 then
   do i= 1 to 12;
        output; 
    end; 
Run;

[Lopa2016]

Thanks for your reply but I have figured it out!!

[Reeza]

Use PEVENT on the model statement to apply a prior probability when running a model with low event rates. 

[Lopa2016]

Thanks Reeza!!