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
> 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
> NOTE: Table MELODY.MELODY_2_SMALL created, with 0 rows and 670
> When trid Ken and Son's method use :
> proc surveyselect data=melody.melody_2 out=melody.melody2_small;
> I also get error.
> Where did I do wrong?
> Thank you again for your help.
You may need to specify the METHOD option. For a simple random sample
without replacement, use METHOD=SRS.