I have the following code applied to the attached file which I need to modify such that I draw sample of N loans from the loan population labelled 'PUR' until the sum of the UPBs reaches 50000.
Any thoughts are welcome.
proc means data=LoanPopulation n;
var Loan_ID;
output=want;
run;
proc surveyselect data=loan_population3
method=srs n=(.8*n) out=PUR_sample;
where purpcd='PUR';
run;
You can try somthing like this
data want;
set have (where=(PURPOSE='PUR'));
call streaminit(12);
if rand("Uniform")<=0.8 then total+upb;
if total>50000 then stop;
run;
You can try somthing like this
data want;
set have (where=(PURPOSE='PUR'));
call streaminit(12);
if rand("Uniform")<=0.8 then total+upb;
if total>50000 then stop;
run;
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!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.