topic Re: Jumbling Observations in SAS Programming

Jumbling Observations

thepushkarsingh — Wed, 28 Feb 2018 17:12:48 GMT

I need to jumble my observations. Like if I have following:

Then I need any jumbled list like:

Any easy idea?

Any code to randomize the order in which observations are in data will be of great help.

Thanks a lot!

HB — Wed, 28 Feb 2018 17:20:39 GMT

This smacks of an XY Problem. Perhaps you could tell us what you are trying to do in a larger context?

In the immediate: You could generate a random number for each observation and then sort by the random number.

mkeintz — Wed, 28 Feb 2018 17:27:31 GMT

Reeza — Wed, 28 Feb 2018 17:35:44 GMT

PROC SURVEYSELECT, no replacement.

SuryaKiran — Wed, 28 Feb 2018 17:45:46 GMT

Check the RAND() function if you have SAS9.4M4 or Later

DATA TEST;
input num;
random_num=RAND("NORMAL");
datalines;
1
2
3
4
5
;
run;

PROC SORT DATA=Test;
by random_num;
run;

Astounding — Wed, 28 Feb 2018 17:48:46 GMT

You should just look at me, and do whatever I do. My observations are always jumbled. At least that's what my wife tells me.

HB — Wed, 28 Feb 2018 17:50:59 GMT

But does she tell you you have an XY Problem? 🙂

ballardw — Thu, 01 Mar 2018 18:13:03 GMT

@HB wrote:

But does she tell you you have an XY Problem? 🙂

Probably just the pesky XY chromosome pairing. 🙂