Bookmark and Share

Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: st: reshaping data


From   Scott Merryman <[email protected]>
To   [email protected]
Subject   Re: st: reshaping data
Date   Wed, 27 Nov 2013 07:41:34 -0600

-reshape- is what you need:

clear
input pupid_1 str4 name_1 age_1 str4 sch_1  pupid_2 str4 name_2 age_2
str4 str4 sch_2 pupid_3 str4 name_3 age_3 str4 sch_3
 231      Jay     13   DA    232     Ren    12    SP    233     Mimi    14   HH
end
gen id = _n
reshape long pupid name age sch, i(id)  string
drop  id _j
l

Scott


On Wed, Nov 27, 2013 at 5:47 AM, Paul Byatta <[email protected]> wrote:
> Hi Statalist,
>
>
> I have a dataset in which an exact set of questions is asked about multiple pupils, hence the data reported looks like this in Stata. For illustration, the data is from 3 pupils.
>
>
> pupid_1 name_1 age_1 sch_1 pupid_2 name_2 age_2 sch_2 pupid_3 name_3 age_3 sch_3
> 231      Jay     13   DA    232     Ren    12    SP    233     Mimi    14   HH
>
> I am wondering is there a short way I could turn the data from the current wide format (where everything appears on the same row) to a long format (where each pupil information will appear on its own row) that will look like below?
>
> pupid name age sch
> 231    Jay  13  DA
> 232    Ren  12  SP
> 233    Mimi 14  HH
>
> I have looked at -reshape- command and it doesnt seem to allow me retain the core of the variable name, ie drop the "_#" part of variable names above and retain the main part.
>
>
> Thanks for the help
>
> Paul
>
*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/


© Copyright 1996–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index