Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: transform the dataset structure


From   sara borelli <[email protected]>
To   [email protected]
Subject   st: transform the dataset structure
Date   Mon, 13 Oct 2008 16:38:50 +0000 (GMT)

Dear Statalist members,

I have the following question.
I have a dataset of the form:

year  italy   france  germany  ...   ...   ... 
1980  209      349     256
1981  567      235     980
1982  129      567     100
...

where the numerical values indicate some expenditure levels. I would like to transfor this dataset into a panel creating the new variable "Expenditure", so that that dataset look like:

expenditure  year  country
    280       1980  italy
    567       1981  italy
    129       1982  italy
    349       1980  france
    235       1981  france
    567       1982  france
    256       1980  germany
    980       1981  germany
    100       1982  germany
.....

any idea on how I can do this?
thank you in advance for any help

Sara Borelli
    


      Scopri il blog di Yahoo! Mail:
Trucchi, novità e scrivi la tua opinione.
http://www.ymailblogit.com/blog

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/



© Copyright 1996–2024 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index