You can use proc sql to do the sampling by making the following changes: - use CREATE TABLE [temporary work dataset] AS and do the INSERT INTO as a separate statement - from INOBS to OUTOBS to limit the number of observations written out to the temporary work dataset to exact number you want for your sample - use ranuni(0) to get a different pseudo-random seed each run (based on clock time) proc sql OUTOBS = &VAR2; CREATE TABLE temp AS SELECT *, ranuni(0) AS SAS_Rand from UCMdb.ttWPSS WHERE zClientName = "&VAR1" ORDER BY SAS_Rand; INSERT INTO wpss.ttWPSS SELECT * FROM temp; quit; This link may be helpful as well: http://www2.sas.com/proceedings/sugi31/168-31.pdf ... View more