create random dataset

[Analyticguru_09]

I'm trying to create a random dataset with 1000 observations and 3 variables(Employee_id, sex, age). I want the employee_id to be in the range (5213 to 9899), sex (as male,female or unknown) and age in between 25 to 75. Is there any function/sas proc thru which i can achieve this? I want the employee id to be random rather than consecutive.Thanks for help

[PGStats · Accepted solution]

A simple way :

proc format;
value sexFmt
     1 = "male"
     2 = "female"
     3 = "unknown";
run;

data test;
format sex sexFmt.;
call streaminit(6875687);
do empId = 5213 to 9899;
     sex = rand("TABLE",0.4,0.4);
     age = 25 + floor(51*rand("UNIFORM"));
     output;
     end;
run;

proc surveyselect data=test out=want n=1000 noprint; run;

PG

[Analyticguru_09]

PGSTATS - Thanks a lot. I learned something new about the streaminit and rand table option.