Page 1 of 1

How do I randomize the order of data?

Posted: Tue Mar 05, 2013 9:45 pm
by 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!

Re: How do I randomize the order of data?

Posted: Tue Mar 05, 2013 11:57 pm
by EViews Gareth
Generate a series of random numbers:

Code: Select all

Series myrand = @rnd
Then sort the workfile by it (sort button).

Re: How do I randomize the order of data?

Posted: Wed Mar 06, 2013 12:08 am
by 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

Re: How do I randomize the order of data?

Posted: Wed Mar 06, 2013 7:36 am
by EViews Gareth
Sorry, use Proc->sort workfile page when looking at a workfile.