Jumbling Observations

[thepushkarsingh]

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

1

2

3

4

5

6

.

Then I need any jumbled list like:

5

3

6

1

4

2

.

Any easy idea?

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

Thanks a lot!

[HB]

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]

1. Make a new random variable. 
2. Sort your data by that variable.

[Reeza]

PROC SURVEYSELECT, no replacement.

https://gist.github.com/statgeek/8a9e15cd823aaf7b54c2d5b1bc6faab1

[SuryaKiran · Accepted solution]

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]

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]

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

[ballardw]

---

@HB wrote:

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

---

Probably just the pesky XY chromosome pairing. 🙂