Hello and sorry if this question is obvious or incorrect,
I have quarterly data from 2007q1 to 2010q4 for 7 variables for 16 countries, which I now have as a single piece of data after using the append command.
However, I cannot set the data as time series data correctly, since I do not know to specify in stata that the periods in question repeat every 16 observations (that being after 2010q4, the data applies to a different country and in 2007q1), as is shown below.
What commands do I have to use to turn the 224 total observations I have into observations on the same 7 variables but for multiple countries over just 16 quarterly periods of time? Or is there a better way I should set out my data so that is is more easily interpreted? I have searched everywhere but cannot find anything that seems to help me, and I cannot advance with my work until this issue is resolved, so any advice or help would be immensely appreciated.
Country Period GDP Inflation
Aus Q1 07 321268.18 .58958402
Aus Q2 07 325467.69 1.1396939
Aus Q3 07 327863.96 .16097875
Aus Q4 07 332522.97 1.2536162
Aus Q1 08 340485.99 .73015873
Aus Q2 08 342633.92 1.4182162
Aus Q3 08 345574.94 .27967682
Aus Q4 08 342928.25 -.21691974
Aus Q1 09 340450.63 -.37267081
Aus Q2 09 338721.5 .59226933
Aus Q3 09 341116.86 .03098853
Aus Q4 09 345863.52 .37174721
Aus Q1 10 343011.12 .40123457
Aus Q2 10 349697.26 1.1374116
Aus Q3 10 354123.9 -.12158055
Aus Q4 10 358890.72 .669507
Bel Q1 07 385205.15 .58302239
Bel Q2 07 387807.08 .55645722
Bel Q3 07 392423.03 .32664668
Bel Q4 07 396691.43 1.2678592
Bel Q1 08 402448.2 1.6302292
Bel Q2 08 407117.12 1.745506
Bel Q3 08 409677.39 .83400395
Bel Q4 08 403639.63 -.74366974
Bel Q1 09 401037.89 -.20832572
Bel Q2 09 402537.68 -.17213595
Bel Q3 09 410486.25 -.09905712
Bel Q4 09 417892.78 .20198311
Bel Q1 10 424470.38 1.05919
Bel Q2 10 433092.96 1.0009429
Bel Q3 10 437502.95 .31597846
Bel Q4 10 442439.45 .5870141
Fin Q1 07 193316.13 .55374593
Fin Q2 07 197516.23 1.1661808
Fin Q3 07 201835.4 .22414345
Fin Q4 07 207047.04 .76677316
Fin Q1 08 209574.72 1.6169943
Related Posts with Help for data with multiple quarterly observations
Help with Stata recognizing numbers between 0 and 1Hello, I am doing a Stata analysis using the variable; agriculture land use (agriculture land/total…
Difference between varsofinterest and alwaysvars in Stata's dsregress commandHi there, I want to need a method for inference with variable selection. To do so, I tried the dsre…
How to find a level of independent variable which change( decrease) independent variable?Hello, everyone. I have multiple regression scorei = β0 + β1clsizei + β2el_pcti + β3comp_stui + β4a…
generating a new variable using bysort in panel datasetHi there, I am currently using StataMP 15.1. I am trying to generate a new variable for the freque…
generate summary stats for eststo with tertilesHi Statalisters, having a real struggle figuring this one hope - really hope someone can help! I a…
Subscribe to:
Post Comments (Atom)
0 Response to Help for data with multiple quarterly observations
Post a Comment