There are a couple of ways. If you want to work from the command line,
then stack will do it. Use ?stack to find the details.
Alternatively, use the stack function under Data->Restructure if you
want to use the graphical interface.
-Neil
On Sat, 2006-04-22 at 14:19 +0100, GRAHAM LEASK wrote:
>
>
> I have a file where "firms" is the column containing the row names and
> I have ten separate "year" columns each with the data for that year.
>
> How can I most simply convert this "wide format" data into long format
> i.e. ten consecutive repetitions of the row names, aligned to one
> column of data and a second column - categorical variable -
> identifying the year which that data corresponds to.
>
> Any help would be greatly appreciated
>
> Kind regards
>
>
> Graham
|