topic create random dataset in SAS Procedures

create random dataset

Analyticguru_09 — Sat, 12 Jan 2013 00:50:59 GMT

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

Re: create random dataset

PGStats — Sat, 12 Jan 2013 02:15:54 GMT

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;

Re: create random dataset

Analyticguru_09 — Mon, 14 Jan 2013 01:16:21 GMT

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