Hi Statalists,
I'm currently dealing with a panel data and here is a example to show what the dataset looks like. Actually it has more than 20000 observations and 6000 variables. Basically, every individual (id) would be interviewed one, two or more times (numeric variable 'wave' and string variable 'surveytime' can tell you when the individual was interviewed). And the rest of variables are answers to according questions in the survey. The point is I'm not sure how to reshape such a huge dataset. Because generally I only use -reshape- command to deal with several variables. And I also don't know how to tell stata that I need reshape all variables (May I ask if macro is required in this situation?)
id state strat raid sah surveytime adst wave
1 A 50 279 78921 19/08/2004 [3] no 4
2 A 50 279 78921 19/07/2004 [3] no 4
3 B 84 143 55441 04/11/2004 [3] no 4
3 B 84 143 42501 01/12/2009 [2] unsure 9
3 B 84 143 196371 06/09/2013 [2] unsure 13
3 B 84 143 193971 03/08/2017 [3] no 17
4 C 84 143 55441 04/10/2004 [3] no 4
I expect to convert current long format data into wide format data according to 'id' and 'wave', i.e. the information of each id from wave 4 to wave 17 will be included in one single row.
Thanks in advance!
Related Posts with How to reshape panel data with a great number of variables
Difference-in-Difference with a series of cross section data*Hello, everyone! I am fairly bad at Stata and it's been some time since I attended any econometrics…
Occupation, education and college cohort fixed effectsI hope someone can help me with this issue in estimating the below model The model includes : The …
Troubles with Propensity score matching and synth_runnerHello! I'm fairly new to stata so there are a few things that I am not sure how to do. I am currentl…
markdown headersDear All, working with markdown command, I am puzzled why the headers, such as Code: # Example are…
Sum from multiple variablesPlease advise syntax for obtaining the total from multiple variables (T1worst_ethos90 T2worst_ethos9…
Subscribe to:
Post Comments (Atom)
0 Response to How to reshape panel data with a great number of variables
Post a Comment