use http://www.ats.ucla.edu/stat/stata/notes/wide, clear describe list reshape long lrn, i(id) j(year) describe list table year, contents(n lrn mean lrn sd lrn) reshape wide describe list reshape long describe list