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.
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.