04-20-2017 08:29 AM
To generate random date in sas, I use this code
data random_date; mindate='01jan2015'd; maxdate='30dec2017'd; range = maxdate-mindate+1; format mindate maxdate randate date9.; do i = 1 to 100000; RanDate = mindate + int(ranuni(12345)*range); output; end; run;
But how can I generate uniques randoms dates ?
04-20-2017 08:42 AM
Well to get rid of duplicates you would do:
proc sort data=randomdate nodupkey; by randate; run;
However I don't think that is what your after is it? You want 10000 unique dates of a random nature yes? If so then just loop over your min/max range, and then sample for the items across this range yes/no 10000 results:
data want; do randate='01jan2015'd to '30dec2017'd; output; end; run; proc surveyselect data=want; method=srs n=10000 out=SampleSRS; run;
Need further help from the community? Please ask a new question.