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: reshape wide with 'repeated' observations


From   "Ojinnaka, Chinedum" <ojinnaka@srph.tamhsc.edu>
To   "statalist@hsphsun2.harvard.edu" <statalist@hsphsun2.harvard.edu>
Subject   RE: st: reshape wide with 'repeated' observations
Date   Tue, 18 Feb 2014 22:56:07 +0000

Other variables within the dataset are in wide format while this particular variable is in long form i.e. the dataset looks like the table provided below. So, I want to get the data in a wide form and reshape it back to long accounting for all the variables that should also be in a long form

>> id      date                   level   R0	 R6     R12     V0 	   V6 	V12
>> 1       02202004        5.6        3  	5  	4      7         5            2
>> 1       04202004        5.4        3  	5  	4      7         5            2
>> 1       06202004        5.6        3  	5  	4      7         5            2

Thanks

-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Nick Cox
Sent: Tuesday, February 18, 2014 4:44 PM
To: statalist@hsphsun2.harvard.edu
Subject: Re: st: reshape wide with 'repeated' observations

OK; so why do you want to do that?
Nick
njcoxstata@gmail.com


On 18 February 2014 20:46, Ojinnaka, Chinedum <ojinnaka@srph.tamhsc.edu> wrote:
> I am sorry about the confusion. Yes, the data is in long form and I want to reshape it to a wide form. However, because some of the observations have similar values like in the table I provided. Stata says the values are not unique to the id. I am wondering if there is a way to get around this problem.
>
> Thank you.
> Chi-Chi
>
> -----Original Message-----
> From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Nick Cox
> Sent: Tuesday, February 18, 2014 1:37 PM
> To: statalist@hsphsun2.harvard.edu
> Subject: Re: st: reshape wide with 'repeated' observations
>
> Your title says "reshape wide" but you say you want to "reshape from wide to long". Stata means "reshape to wide" when it says "reshape wide" and similarly for "long".
>
> In your case, the example data appear to be already in long form with identifier repeated for each observation. For most panel or longitudinal tasks, this is what you need, so if I understand you correctly, there is no problem to be fixed.
>
> Nick
> njcoxstata@gmail.com
>
> On 18 February 2014 17:05, Ojinnaka, Chinedum <ojinnaka@srph.tamhsc.edu> wrote:
>
>> I want to reshape a dataset from wide to long. The variable of interest is a measure that can be repeated multiple times with the same measurement (example provided in table below), thus, I received an error message saying that values of the variable are not unique within the studyid. Is there anything that can be done about this?
>>
>> id      date                   level
>> 1       02202004        5.6
>> 1       04202004        5.4
>> 1       06202004        5.6
>
> *
> *   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/
>
> *
> *   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/

*
*   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/

*
*   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