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

[Miranda Kim <mk@mrc.soton.ac.uk>]

Thanks a lot for this.
It looks like
estout using myfile.csv, replace cells("min & max") incell("-")
sorts out the hyphen, but I don't know how to put the parentheses.
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/