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!