topic Re: Select random observation. in SAS Studio

Select random observation.

Bipingaud — Mon, 05 Sep 2016 15:59:02 GMT

Hii, can any one plz tell how can we retrieve a single random observation(row) from a data set?

Re: question.

Shmuel — Mon, 05 Sep 2016 15:39:02 GMT

you can use:

set input(obs=1, firstobs=) ; /* change firstobs to any row number you want */

Re: question.

BrunoMueller — Mon, 05 Sep 2016 15:56:35 GMT

You can use some options on the SET statement to achieve this, see example below. Please be aware when using the POINT= option, you also need a STOP statement, as otherwise the DATA Step will loop. Have a look in the doc at the description of the POINT= and NOBS= options. The variable name used in the POINT= option is not written to the output dataset, this is why I use two variables.

data want;
  getObs = ceil( ranuni(0) * numObs);
  _getObs = getObs;
  set sashelp.cars point=_getObs nobs=numObs;
  output;
  stop;
run;

Also look at Proc SURVEYSELECT for more sophisticated ways to get a random sample from a SAS data set

Bruno

Re: Select random observation.

Ksharp — Tue, 06 Sep 2016 06:07:15 GMT


proc surveyselect data=sashelp.class out=want sampsize=1;
run;