Thanks for the response and the answer. I checked the link you sent me before. The data constructed differently still from those cases presented by the link you sent me. Still have problem since need to seperate both, year and variable.
I here attach a file which might help you understand it better.
Search found 2 matches
- Mon May 16, 2011 8:20 am
- Forum: Data Manipulation
- Topic: Converting timeseries to Panel Data
- Replies: 3
- Views: 5507
- Mon May 16, 2011 5:41 am
- Forum: Data Manipulation
- Topic: Converting timeseries to Panel Data
- Replies: 3
- Views: 5507
Converting timeseries to Panel Data
I run a pilot project which will eventually lead to a large scale of data management in the next phrase of the project. I need to convert standard reports from a database to panel data. The reports are retrieved from the database in the following format. In the real case I will have more than 20 var...