BookmarkSubscribeRSS Feed
Jackie_Stanbank
Calcite | Level 5

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?

2 REPLIES 2
art297
Opal | Level 21

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.

data_null__
Jade | Level 19

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;

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 959 views
  • 0 likes
  • 3 in conversation