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