Hello Statalisters,
I have downloaded some information from NZ.Stat (New Zealand Quarterly Work Statistics) and am having trouble reshaping due to the format of the data. I've posted an example so you can see what I mean. The data is downloadable (the easy part), but the format is layered in a way where I can't retain the region-specific information with the industry sector. Is there some way I can connect the region (in row 2) and add it to industry type (from row 3) and then reshape from wide to long so I can then collapse to get the annual figures for each year in the data? I know each of these commands so I don't need help with anything past the first (and most challenging step). See the thumbnail for the format of the data as it show in STATA and the csv file for the raw data that was imported to STATA. I have put in a request for NZ Stats to create this for me, but it accrues a cost for custom files, and since I have the data it doesn't make sense for me to pay for something that just needs a bit of manipulation to be useful for my project.
Best,
Davia Downey
Related Posts with Reshape Problem
Stata 17 Features Leaked Default precision changed to double regress now supports multiway clustering of standard errors Dof…
how to customize the location of legendI know the way of using position() to customize the location of legend, but sometimes the legend wil…
ldev following logistic inconsistent with estat gof and with Hosmer & LemeshowI am trying to reproduce Hosmer & Lemeshow's example (3rd edition, Table 4.16, p115). With 'logi…
Error message when obtaining SVAR's IRFDear all, I am trying to obtain simple Impulse Response Functions after running a SVAR. Code: ma…
Matching data over three waves of income surveysDear all, I am conducting an analysis where I want to see the effects of weather on income in Bangl…
Subscribe to:
Post Comments (Atom)
0 Response to Reshape Problem
Post a Comment