Reshape Long

[Caroline Calogero]

Hey, I'm a lost soul currently wandering through regressions in Stata. Can you please help ;(.

I need to reshape my data list to where the year and types of crime is a variable in a column which can allow me to merge my data sets. Thanks!!

[Richard Williams]

As an aside, in case people haven't noticed, there seem to be some dramatic improvements to reshape in the latest update to version 18.


1. reshape has new option favor(), which allows you to specify that Stata favor memory or speed when reshaping data. New setting set reshape_favor allows you to do the same thing.

When reshape favors speed, it now reshapes the data much faster. Depending on the size of the dataset, the reshape may be 10 times, 100 times, or even more times faster.

[Daniel Schaefer]

Caroline,

I doubt anyone here is going to open an excel spreadsheet to see your data. It is not safe to download .xlsx sheets unless you trust the source. Please generate a data example with -dataex- and paste it in a new reply. Be sure to surround the data example with CODE tags (see the hashtag symbol in the editor).