- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
PGSTATS - Thanks a lot. I learned something new about the streaminit and rand table option.