On Jan 22, 9:14 am, Melodyp <pearsonmel...@gmail.com> wrote: > On Jan 21, 3:47 pm, Melodyp <pearsonmel...@gmail.com> wrote: > > > Hello! I have a question on how to select about 8500 records from a > > nearly one million records dataset. > > > The 8500 records must be randomly selected. > > > Thank you in advance for your help. > > > Melody > > Thank you Julia, Ken and son for your helps. > When tried the method Julia provided, I obtianed the following error: > =========================================================== > 2 proc sql outobs = 8500; > 3 create table melody.Melody_2_small as > 4 select A.* > 5 from melody.melody_2 as A > 6 order by ranuni(4537); > NOTE: The query as specified involves ordering by an item that doesn't > appear in its SELECT clause. > ERROR: Write to WORK._tf0006.UTILITY failed. File is full and may be > damaged. > NOTE: Error was encountered during utility-file processing. You may be > able to execute the SQL > statement successfully if you allocate more space to the WORK > library. > NOTE: Table MELODY.MELODY_2_SMALL created, with 0 rows and 670 > columns. > =========================================================== > > When trid Ken and Son's method use : > proc surveyselect data=melody.melody_2 out=melody.melody2_small; > sampsize=8500; > run; > > I also get error. > > Where did I do wrong? > > Thank you again for your help. > > Melody

You may need to specify the METHOD option. For a simple random sample without replacement, use METHOD=SRS.