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!!
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.