Dear all,
I am attempting to manipulate the panel data as time series data using the command:
‘tsset countrySCM year’, however I have duplicate data because my variables are associated with a country for the same year. See below for an example:
input str14 country str4 var str38 industry int year str18 currency str9 powercode double value float(euro_V output value_added GrossFCF Labour_C Ee) long countrySCM byte isdup
"Australia" "LABR" " Agriculture, forestry and fishing [A]" 1970 "Australian Dollar" "Millions" 591 319.14 . . . 319.14 . 1 2
"Australia" "GFCF" " Agriculture, forestry and fishing [A]" 1970 "Australian Dollar" "Millions" 2428 1311.12 . . 1311.12 . . 1 2
"Australia" "VALU" " Agriculture, forestry and fishing [A]" 1970 "Australian Dollar" "Millions" 2311 1247.94 . 1247.94 . . . 1 2
"Australia" "GFCF" " Agriculture, forestry and fishing [A]" 1971 "Australian Dollar" "Millions" 2467 1332.18 . . 1332.18 . . 1 3
"Australia" "EMPN" " Agriculture, forestry and fishing [A]" 1971 "Persons" "Millions" 411.709 . . . . . .411709 1 3
"Australia" "VALU" " Agriculture, forestry and fishing [A]" 1971 "Australian Dollar" "Millions" 2619 1414.26 . 1414.26 . . . 1 3
"Australia" "LABR" " Agriculture, forestry and fishing [A]" 1971 "Australian Dollar" "Millions" 596 321.84 .
As above, I want all the data for Australia in 1970 to be on the same row. The variables I have generated are all the formatted as long. The countrySCM is the numeric var of country. The isdup variable is part of my attempt to find an answer and can be ignored in this topic.
Before proceeding, although I used the dataex cmd I do not know how to format it more clearly, if someone told me how I would be happy to do that first.
Kind regards,
Lucas
Related Posts with Problem with panel data - data that is on different columns to be on the same row to stop duplications.
Random sampleHello to all, I try to learn stata by myself as a economist, So I want to make a boucle to make a r…
Manual SE adjustment for 2SLS with clusteringHello, I'd like to manually estimate a two-stage least squares regression, first running the first …
Panel Data Question I could not find in any bookHi All, I have read several manuals on panel data econometrics but I never found the answer to thes…
clustered standard error with IVDear all I am estimating IV model. I would like to cluster at the village level We have only two vi…
how to count the distribution of industry in the sampleHi, I would like to have an overview of the industry distribution in my sample to see which industr…
Subscribe to:
Post Comments (Atom)
0 Response to Problem with panel data - data that is on different columns to be on the same row to stop duplications.
Post a Comment