Help using Base SAS procedures

Even Disctribution

Reply
Occasional Contributor
Posts: 11

Even Disctribution

Hi

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?

PROC Star
Posts: 7,363

Even Disctribution

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.

Respected Advisor
Posts: 3,777

Re: Even Disctribution

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;

Ask a Question
Discussion stats
  • 2 replies
  • 134 views
  • 0 likes
  • 3 in conversation