Thanks for spelling it out.
Nick
[email protected]
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Joao Ricardo F. Lima
Sent: 26 August 2009 16:26
To: [email protected]
Subject: Re: st: How to transpose columns into rows?
Nick,
thanks! Now I see. The correct is
****
cap ssc inst sxpose
clear
input str6 var1 str6 var2
name xxyy
year 37
gender female
end
sxpose, clear firstnames
list
********
Joao Lima
2009/8/26 Nick Cox <[email protected]>:
> No. The -string- option of -reshape- is not a switch that has to do with string variables.
>
> A solution has already been signalled to Zoe: to look at -sxpose- from SSC.
>
> Nick
> [email protected]
>
> Joao Ricardo F. Lima
>
> cant you use -reshape- with the string option?
>
>
> 2009/8/24 ZoeW <[email protected]>:
>
>> How to transpose column into row?
>>
>> I have 2 variables (in column) with 10 observations (rows). They are all strings. Now I want to transpose them. Tried xpose, but all the strings were turned into missing. I want to keep the strings as is.
>>
>> Example:
>>
>> Column1 C2
>> Name XXYY
>> YEAR 37
>> Gender female
>>
>> I want to change them into
>> Name Year Gender
>> XXYY 37 female
>
> *
> * 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/
>
--
----------------------------------------
Joao Ricardo Lima, D.Sc.
Professor
UFPB-CCA-DCFS
Fone: +5538387264913
Skype: joao_ricardo_lima
----------------------------------------
*
* 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/
