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!!
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;
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;
Thanks for your reply but I have figured it out!!
Use PEVENT on the model statement to apply a prior probability when running a model with low event rates.
Thanks Reeza!!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Use this tutorial as a handy guide to weigh the pros and cons of these commonly used machine learning algorithms.
Find more tutorials on the SAS Users YouTube channel.