Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
From | "Fiedler, James (JSC-SK)[UNIVERSITIES SPACE RESEARCH ASSOC-DIV OF SPACE LIFE SCIENCES]" <james.fiedler-1@nasa.gov> |
To | "statalist@hsphsun2.harvard.edu" <statalist@hsphsun2.harvard.edu> |
Subject | RE: st: Reshape problem |
Date | Wed, 22 Aug 2012 13:52:40 -0500 |
Actually, my code doesn't get the variables names the way you want. You'd have to do something differently for that part. ________________________________________ From: owner-statalist@hsphsun2.harvard.edu [owner-statalist@hsphsun2.harvard.edu] On Behalf Of Fiedler, James (JSC-SK)[UNIVERSITIES SPACE RESEARCH ASSOC-DIV OF SPACE LIFE SCIENCES] [james.fiedler-1@nasa.gov] Sent: Wednesday, August 22, 2012 1:47 PM To: statalist@hsphsun2.harvard.edu Subject: RE: st: Reshape problem Agreeing with the other responses, it does look like you want to transpose the data. Here's some code that (I think) gets the data the way you want it. input mAug_99 mSep_99 mOct_99 str6 variables 1 3 5 v1 2 4 6 v11 end xpose , varname clear drop in l rename _varname month replace month = substr(month, 2, .) James ________________________________________ From: owner-statalist@hsphsun2.harvard.edu [owner-statalist@hsphsun2.harvard.edu] On Behalf Of Olivia Bacha [oliviabacha@gmail.com] Sent: Wednesday, August 22, 2012 1:45 PM To: statalist@hsphsun2.harvard.edu Subject: Re: st: Reshape problem It is not much clear to me what you want to do. If you just want to transpose your data try xpose, clear Regards, Olivia 2012/8/22 Dorothy Bridges <dbstata@gmail.com>: > You could try: > > reshape long m, i(variables) j(month) > reshape wide m, i(month) j(variables, string) > > You could also look into xpose and sxpose. > > On Wed, Aug 22, 2012 at 11:25 AM, Pedro Nakashima > <nakashimapedrolist@gmail.com> wrote: >> Dear statalisters >> >> I'm using Stata 12 >> >> I'm trying to put a data in the form: >> >> input mAug_99 mSep_99 mOct_99 str6 variables >> 1 3 5 v1 >> 2 4 6 v11 >> end >> >> into other like: >> >> input v1 v11 month >> 1 2 Aug_99 >> 3 4 Sep_99 >> 5 6 Oct_99 >> end >> >> I tryied the command >> >> reshape long m, i(variables) j(month) >> >> but it didn't create the variables v1 and v11, which I wanted >> >> Thanks for any help >> >> Best, >> Pedro. >> * >> * 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/ > * > * 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/ * * 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/ * * 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/ * * 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/