Transposing an imported Excel file
Posted: Mon Aug 03, 2015 8:25 am
I am seeking to import an Excel file into Eviews8, the dataset is relatively large (500 variables x 50 years) such that the data is set horizontally a opposed to vertically. As such, I need to transpose the data prior to importing it (please see the attached Excel file for an example of how the data is structured). I usually import data, for vertically-oriented Excel files, with the following command:
pageselect A3260031
import "path\CANSIM 326-0031.xls" range="Eviews" colhead=2 namepos=first @freq A 1960
What should I add to make sure the data is transposed? Thank you much in advance!
pageselect A3260031
import "path\CANSIM 326-0031.xls" range="Eviews" colhead=2 namepos=first @freq A 1960
What should I add to make sure the data is transposed? Thank you much in advance!