Statalist


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

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


From   "Martin Weiss" <martin.weiss1@gmx.de>
To   <statalist@hsphsun2.harvard.edu>
Subject   AW: AW: AW: st: AW: Export Mata matrix into Excel
Date   Thu, 17 Dec 2009 16:05:05 +0100

<> 

Works for me:


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



HTH
Martin


-----Ursprüngliche Nachricht-----
Von: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Miranda Kim
Gesendet: Donnerstag, 17. Dezember 2009 16:00
An: statalist@hsphsun2.harvard.edu
Betreff: Re: AW: AW: st: AW: Export Mata matrix into Excel

Thanks a lot Martin!
I've tried using incelldelimiter() for the hyphen but so far with no 
success.
BW
Miranda

Martin Weiss wrote:
> <> 
>
> 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: owner-statalist@hsphsun2.harvard.edu
> [mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Martin Weiss
> Gesendet: Donnerstag, 17. Dezember 2009 15:16
> An: statalist@hsphsun2.harvard.edu
> 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: owner-statalist@hsphsun2.harvard.edu
> [mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Miranda Kim
> Gesendet: Donnerstag, 17. Dezember 2009 14:53
> An: statalist@hsphsun2.harvard.edu
> 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: owner-statalist@hsphsun2.harvard.edu
>> [mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Miranda Kim
>> Gesendet: Donnerstag, 17. Dezember 2009 14:30
>> An: statalist@hsphsun2.harvard.edu
>> 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: owner-statalist@hsphsun2.harvard.edu
>>> [mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Miranda Kim
>>> Gesendet: Donnerstag, 17. Dezember 2009 12:12
>>> An: statalist@hsphsun2.harvard.edu
>>> 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/
>
>
>   

*
*   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–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index