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 problem
From
Pedro Nakashima <[email protected]>
To
[email protected]
Subject
Re: st: Reshape problem
Date
Wed, 22 Aug 2012 16:42:38 -0300
Thank you very much, James Fiedler
It worked perfectly well !!
Best,
Pedro.
2012/8/22 Fiedler, James (JSC-SK)[UNIVERSITIES SPACE RESEARCH
ASSOC-DIV OF SPACE LIFE SCIENCES] <[email protected]>:
> Ok, second attempt. I think this gets what you want, and I think it's general enough to work in a real situation. It's probably not the most elegant solution, though.
>
> It saves the variable names in individual locals. There might be a better to do this, but I'm guessing this is fine when there are just a few variable names.
>
>
>
> input mAug_99 mSep_99 mOct_99 str6 variables
> 1 3 5 v1
> 2 4 6 v11
> end
>
> local N = _N
> forv i=1(1)`N' {
> local name`i' = variables[`i']
> }
>
> xpose , varname clear
>
> local counter = 0
> foreach var of varlist * {
> local counter = `counter' + 1
> if ("`name`counter''" != "") {
> rename `var' `name`counter''
> }
> }
>
> drop in l
> rename _varname month
> replace month = substr(month, 2, .)
>
>
>
>
> James
>
> ________________________________________
> From: [email protected] [[email protected]] On Behalf Of Fiedler, James (JSC-SK)[UNIVERSITIES SPACE RESEARCH ASSOC-DIV OF SPACE LIFE SCIENCES] [[email protected]]
> Sent: Wednesday, August 22, 2012 1:52 PM
> To: [email protected]
> Subject: RE: st: Reshape problem
>
> Actually, my code doesn't get the variables names the way you want. You'd have to do something differently for that part.
>
>
> ________________________________________
> From: [email protected] [[email protected]] On Behalf Of Fiedler, James (JSC-SK)[UNIVERSITIES SPACE RESEARCH ASSOC-DIV OF SPACE LIFE SCIENCES] [[email protected]]
> Sent: Wednesday, August 22, 2012 1:47 PM
> To: [email protected]
> 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: [email protected] [[email protected]] On Behalf Of Olivia Bacha [[email protected]]
> Sent: Wednesday, August 22, 2012 1:45 PM
> To: [email protected]
> 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 <[email protected]>:
>> 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
>> <[email protected]> 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/
>
> *
> * 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/