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 problem


From   "Fiedler, James (JSC-SK)[UNIVERSITIES SPACE RESEARCH ASSOC-DIV OF SPACE LIFE SCIENCES]" <[email protected]>
To   "[email protected]" <[email protected]>
Subject   RE: st: Reshape problem
Date   Wed, 22 Aug 2012 14:04:07 -0500

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/


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