How do I randomize the order of data?

[jennystats]

Hi,

I have a dataset with about 400 observations. I want to sort them randomly but I'm not sure how.

Any help appreciated. Thanks!

[EViews Gareth]

Generate a series of random numbers:

Code: Select all

Series myrand = @rnd

Then sort the workfile by it (sort button).

[jennystats]

Hey Gareth,

Thanks for the help. I generated the random series but when I open my other series (let's just call it Series1) there is only the option to sort in ascending or descending order, not by another series.

It says:

Sort key
<Observation Order> or SERIES1 in a dropdown box

and then Ascending or Descending in another dropdown box immediately to the right

[EViews Gareth]

Sorry, use Proc->sort workfile page when looking at a workfile.