topic Re: Even Disctribution in SAS Procedures

Even Disctribution

Jackie_Stanbank — Tue, 04 Oct 2011 13:35:31 GMT

I have a list of 4 users and a list of 20 000 accounts and want to randomly distribute the accounts amongst the users evenly.

Is there a proc that i can use for this?

Even Disctribution

art297 — Tue, 04 Oct 2011 13:50:58 GMT

I think that you could just use one of the random functions (e.g., http://kb.iu.edu/data/aehl.html ) or, if the assignment is more complex, take a look at proc plan.

Re: Even Disctribution

data_null__ — Tue, 04 Oct 2011 15:54:50 GMT

Two methods one exact.

data need;
   do account=1 to 2e5;
      user = rantbl(12345,.25,.25,.25,.25);
      output;
      end;
   run;
proc freq;
   tables user;
   run;
 
data need;
   do account=1 to 2e5;
      user=ranuni(12345);
      output;
      end;
   run;
proc rank group=4 out=need;
   var user;
   run;
proc freq;
   tables user;
   run;