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
Rename variables numerically through loopHello, I am trying to rename all variables in my dataset to something informative, rather than r4, …
about tuples:why observation numbers are out of range ? It should't beMy university has bought Stata 15.1MP with 12 cores. I only include 12 variables in for tuples comma…
Create string variable that copies all string letters from other variable up to specific lettersHi I would like to create a string variable that copies all characters from another string variable…
Panel data random effects with small n and large t autocorrelation problemI have a panel data random effects model with n=14 and t=38. I have tested for autocorrelation with…
Help on VECMHi guys! I have a quick question regarding the CE results for VECM and performing Error Correction …
Subscribe to:
Post Comments (Atom)
0 Response to Reshape command with quarterly data
Post a Comment