I have a data set that I would like to 'reshape' to a record per row.
All variables except one, the 'request' variable are on a single row per
identifier. The request variable can be any number of rows and contains
both string and numeric data, with the codes I am interested in
appearing in no particular order in the column. I would like to
reshape this variable so it's on one row with the identifier. I have
explored -xpose- and -sxpose- and reshape but cannot achieve this.
(Their are more than 3 variables in the data set).
identifier dob request
ss12345 10 04 68 MA4
A2
ST69979
verygood
ss12346 21 3 52 .
ss12347 14 8 71 MA2
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
