Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

AW: AW: st: AW: Export Mata matrix into Excel


From   "Martin Weiss" <[email protected]>
To   <[email protected]>
Subject   AW: AW: st: AW: Export Mata matrix into Excel
Date   Thu, 17 Dec 2009 15:18:57 +0100

<> 

Sorry, code should be:


*************
sysuse auto, clear
estpost tabstat price weight length, stat(min max) c(stat)
estout using myfile.csv, cells("min & max") replace
!start myfile.csv
*************



HTH
Martin


-----Ursprüngliche Nachricht-----
Von: [email protected]
[mailto:[email protected]] Im Auftrag von Martin Weiss
Gesendet: Donnerstag, 17. Dezember 2009 15:16
An: [email protected]
Betreff: AW: AW: st: AW: Export Mata matrix into Excel

<> 


*************
sysuse auto, clear
estout using myfile.csv, cells("min & max") replace
!start myfile.csv
*************

No idea how to sneak the hyphen into this...



HTH
Martin


-----Ursprüngliche Nachricht-----
Von: [email protected]
[mailto:[email protected]] Im Auftrag von Miranda Kim
Gesendet: Donnerstag, 17. Dezember 2009 14:53
An: [email protected]
Betreff: Re: AW: st: AW: Export Mata matrix into Excel

Thank you so much, I hadn't spotted that option! Do you know how I would 
get the following format in the cell for example: "(min-max)"
i.e with the parentheses and the hyphen?
BW
Miranda

Martin Weiss wrote:
> <> 
>
>
> I think the -cells()- option to -ssc d estout- can achieve this effect
with
> the ampersand "&"...
>
>
> HTH
> Martin
>
>
> -----Ursprüngliche Nachricht-----
> Von: [email protected]
> [mailto:[email protected]] Im Auftrag von Miranda Kim
> Gesendet: Donnerstag, 17. Dezember 2009 14:30
> An: [email protected]
> Betreff: Re: st: AW: Export Mata matrix into Excel
>
> I want to produce tables with summary statistics that can include 
> columns with more than one statistic within a cell. For example the "min 
> ; max" or the interquartile range "p25 ; p75". I didn't manage to get 
> esttab to do this.
> BW
> Miranda
>
> Martin Weiss wrote:
>   
>> <> 
>>
>> -ssc d esttab- and -ssc d mat2txt- come to mind generally. The -mata-
>>     
> thing
>   
>> is special, though. What do you want to accomplish with the matrix
>> transformation?
>>
>>
>>
>> HTH
>> Martin
>>
>>
>> -----Ursprüngliche Nachricht-----
>> Von: [email protected]
>> [mailto:[email protected]] Im Auftrag von Miranda Kim
>> Gesendet: Donnerstag, 17. Dezember 2009 12:12
>> An: [email protected]
>> Betreff: st: Export Mata matrix into Excel
>>
>> I am using mata for the first time and want to export a string matrix 
>> into excel.
>> Any suggestions would be much appreciated.
>> I am a Stata 11 user.
>> Many thanks,
>> Miranda
>>
>> *
>> *   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/



© Copyright 1996–2024 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index