More Sampling

maroulator — Wed, 16 Jul 2014 19:42:59 GMT

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;

Re: More Sampling

stat_sas — Wed, 16 Jul 2014 20:31:41 GMT

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;

topic Re: More Sampling in SAS Programming

More Sampling

Re: More Sampling