Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
| From | Christopher Baum <kit.baum@bc.edu> |
| To | "statalist@hsphsun2.harvard.edu" <statalist@hsphsun2.harvard.edu> |
| Subject | re:st: Data structure - left adjusted - numeric variable |
| Date | Tue, 3 Apr 2012 19:56:09 -0400 |
<>
clear
input id f1 f2 f3 f4 f5 f6
1 . 12 23 . . 56
2 . 62 . . . .
3 881 . 453 34 55 .
4 . 92 . . . .
5 . 62 . . . .
6 . . . . . 67
7 91 . . . 87 .
8 . . . 66 . .
9 . . 53 . . 76
end
reshape long f, i(id)
drop _j
drop if mi(f)
by id: g fnr = _n
reshape wide f, i(id) j(fnr)
l
Kit Baum | Boston College Economics & DIW Berlin | http://ideas.repec.org/e/pba1.html
An Introduction to Stata Programming | http://www.stata-press.com/books/isp.html
An Introduction to Modern Econometrics Using Stata | http://www.stata-press.com/books/imeus.html
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/