Long-var(s) is the name of the long variable(s) to be made wide e.g. reshape wide long-var(s), i( wide-id-var ) j( var-with-suffix ) where The general syntax of reshape wide can be expressedĪs. Reshape wide age, j(birth) i(famid) Wide format J variable (2 values) dadmom -> (dropped) reshape wide name inc, i(famid) j(dadmom) string The string option to tell Stata that the suffix is character. Let’s reshape this to be in a wide format, containing one record per family. Reshape can handle character suffixes as well.Ĭonsider the dadmoml data file shown below. The examples above showed how to reshape data using numeric suffixes, but Using the reshape command, you can convert the long format into the wide format. The unit of observation for the wide format is individual (within family). Reshape wide kidname age wt sex, i(famid) j(birth)Įxample #3: Reshaping wide with character suffixes In the 2nd example, the unit of observation for the long format is each birth within family (individual)-age'. Reshape the variables age, wt and sex like this. In the example above, we just reshaped the age variable. The reshape command can work on more than one variable at a time. J(birth) tells reshape that the suffix of age (1 2 3) should be taken from the variable birth Example #2: Reshaping data long to wide with more than one variable I(famid) tells reshape that famid uniquely identifies observations in the wide form Stata that the variable to be converted from long to wide is age Wide tells reshape that we want to go from long to wide

Let’s look at the pieces of the reshape command. ( age2 would be missing if there is only 1 kid, and age3 would be missing if there are only 2 Let’s make age in this file wide, making one record per family which would contain age1 age2 age3, the ages of the kids in the family (To make things simple at first, we will drop the variables kidname sex and The reshape command can be used to make data from a long format to a wide format. Show common examples of reshaping data but do not exhaustively demonstrate theĭifferent kinds of data reshaping that you could encounter.

These examples take long data files and reshape them into wide form. And simplicity of Stata in its ability to reshape data files.

Reshape long stata