<>
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: [email protected]
[mailto:[email protected]] Im Auftrag von Miranda Kim
Gesendet: Donnerstag, 17. Dezember 2009 16:00
An: [email protected]
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: [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/
>
>
>
*
* 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/
