Reshape

reshape long|wide stubnames[@], i(varlist) [j(varlist)]

• stubnames
  • names of variables that are being converted between columns and rows
  • If they're numbered, stata should figure it out or you can use @ to indicate the number
  • you can use multiple columns as stubnames
• varlist - identifying variable(s)
  • In long form, there should be duplicate values; in wide form they should be unique.
• varname - variable indicating column number

SSN age inc03 inc04 inc05 346752468 54 56 58 61 348576425 51 73 76 77 346512487 38 40 41 41

® reshape long inc, i(SSN) j(year) reshape wide inc, i(SSN) j(year) ¬

SSN age year inc 346752468 54 03 56 346752468 54 04 58 346752468 54 05 61 348576425 51 03 73 348576425 51 04 76 348576425 51 05 77 346512487 38 03 40 346512487 38 04 41 346512487 38 05 41