Hi, could I reduce the time sas EG run the code

[ChrisHemedinger]

PROC SURVEYSELECT might not be optimized to pull a random sample from a large database. You might look at an SQL technique that allows you to push more of that work to the database. Here's a paper that describes the technique:

http://www2.sas.com/proceedings/sugi31/168-31.pdf

[bohonghong]

Thanks for everyone's input, so fast wow! I felt so grateful for your time and dedication. Happy Friday.