I would like to reshape my data from wide to long format. My headers are dates every quarter so 31-1-2000 31-3-2000 30-6-2000 31-12-2000 31-1-2001 etc. and my ID value is Country so in column A a list of around 200 countries
I tried changing my headers to be something in the ballpark of Q1 2020 Claims to add a stub to it but even when doing this i cant seem to get the correct result of each country having all 81 quarters list seperately
Ive added a picture below to show what my data looks like at the moment.
Array
Related Posts with Reshape command with quarterly data
Postestimation for mlogit: statistically significant differences in predicted probabilitiesI ran multinomial logit model (code below). Dependent variableis gender (M, F, Unknown). Model has o…
Issues with Time-Invariant Variables when using Stack Command in panel regressionHi everyone - I'm trying to use the stack command to compare the effects of the same independent va…
Adding dots to the top of a line in graph twowayHi all, I am trying to put dots on certain months similar to the graph below. Do you know how to do …
gsem: Same code, no longer workingHello, I am using gsem in Stata 15 for an LCA, and although I have been using Stata for some time, …
Ouput tests for difference in coefficients from one regression; how to output multiple tests in same columnI have searched the forum and was unable to find the answer to my question. Granted, the title of my…
Subscribe to:
Post Comments (Atom)
0 Response to Reshape command with quarterly data
Post a Comment