topic SAS Extrapolation in SAS Data Science

SAS Extrapolation

Lopa2016 — Wed, 25 Jan 2017 10:34:49 GMT

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!!

Re: SAS Extrapolation

Kalind_Patel — Wed, 25 Jan 2017 11:00:11 GMT

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;

Re: SAS Extrapolation

Lopa2016 — Wed, 25 Jan 2017 11:10:46 GMT

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

Re: SAS Extrapolation

Reeza — Wed, 25 Jan 2017 12:18:40 GMT

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

Re: SAS Extrapolation

Lopa2016 — Wed, 25 Jan 2017 14:42:33 GMT

Thanks Reeza!!