Thanks. This is my first attempt with SAS and if possible would like to know if this is doable via dialog boxes. Here is a copy of the log from the dialog box using strata based on the ID. Is there a small adjustment to be made to this log that would make it work. /* ------------------------------------------------------------------- Code generated by SAS Task Generated on: Saturday, July 02, 2011 at 4:15:00 PM By task: Random Sample Input data: WORK.Hfile1 Server: Local ------------------------------------------------------------------- */ %_eg_conditional_dropds(WORK.SORTTempTableSorted, WORK.RANDRandomSampleHfile1); PROC SORT DATA=WORK.Hfile1() OUT=WORK.SORTTempTableSorted; BY ID; RUN; PROC SURVEYSELECT DATA=WORK.SORTTempTableSorted OUT=WORK.RANDRandomSampleHfile1 METHOD=SRS RATE=%SYSEVALF(10/100); STRATA ID / ALLOC=PROP; RUN; QUIT; %_eg_conditional_dropds(WORK.SORTTempTableSorted);
... View more
