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?
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.
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;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.