topic Re: Create random sample from a dataset in SAS Programming

Create random sample from a dataset

hhchenfx — Sat, 23 Jan 2021 04:14:07 GMT

Hi,

It is a simple way to get random 100 row from your dataset.

HHCFX

proc sql outobs=100;
create table WANT as select * from HAVE order by ranuni(0);quit;

Re: Create random sample from a dataset

hhchenfx — Sat, 23 Jan 2021 04:14:27 GMT

proc sql outobs=100; create table random as select * from a order by ranuni(0);quit;

Re: Create random sample from a dataset

Rick_SAS — Sat, 23 Jan 2021 11:13:22 GMT

Specifically, this selects 100 rows WITHOUT REPLACEMENT. That is, the rows are unique. In some applications, you might need other sampling schemes, such as selection WITH replacement. The SURVEYSELECT procedure is a general way to select rows from a data set. It supports many different sampling schemes: with replacement, without replacement, stratified sampling, and more.

See this article for a discussion and an example of ways to sample with replacement in SAS.