More Sampling

[maroulator]

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;

[stat_sas · Accepted solution]

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;