@Tom  Thanks for your response.    However, I have not posted any code. Maybe you wanted to say - The code posted here has opposite problem.    Thank you.   - Dr. Abhijeet Safai ... View more

Hi! If you are going to be involved in a lot of sampling then you should definitely get familiar with SURVEYSELECT. I haven't a full knowledge of the procedure but, anyway, here is how I would accomplish your sampling : data test; call streaminit(3746); do user = 1 to 30;       do j = 1 to 1 + rand("POISSON",3);           claim = user * 100 + j;           output;           end;      end; drop j; run; /* Select some user's claims as clusters */ proc surveyselect data=test out=temp n=10; samplingunit user; run; /* Select one claim per selected user */ proc surveyselect data=temp out=want n=1; strata user; run; PG ... View more

how about applying the format DTDATE. instead of DATETIME.? then you don't need to change the values stored could do this in a PROC DATASETS step instead of re-writing the data ... View more