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

Re: st: display width in tabulate

From   "Sergiy Radyakin" <>
Subject   Re: st: display width in tabulate
Date   Fri, 19 Dec 2008 11:44:34 -0500

Hello David,

you probably mean "export to an Excel table".

If so,  -XML_TAB- is a user written program which will be helpful in
your case. Put your statistics into a matrix, and whatever strings
(originating from a string variable or labels) into rownames. After
that type:

xml_tab M, save("filename.xml")

Don't worry about the xml extension. Modern versions of Excel will
accept these files just fine. It will also give you a link on the
screen, so all you have to do next is "click here".

The help file for xml_tab provides detailed description of the many
formatting options, as well as nice features, like appending sheets,
exporting regressions' output, etc.  In particular cwidth() option
will allow you to control the width of each individual column in your

Best wishes,
   Sergiy Radyakin

On Fri, Dec 19, 2008 at 9:28 AM, David Kantor <> wrote:
> Hello.
> I'm doing a simple two-way tabulation. The first variable is value-labelled,
> with some rather long values; some are as much as 46 characters.
> (I believe that the fact that they are label values is irrelevant; if it
> were a string-valued variable, I believe that the result would look the
> same.)
> The output is coming out with those values (in the left margin), truncated
> to 21 characters.
> Does anyone know a way to make them appear in full value? That may look
> absurd, but it is what I need for now.
> My goal is to import the output to an Excel table - with full-length string
> values. As it stands now, I am manually fixing the ones that were truncated.
> So maybe there is some other way besides -tabulate-.
> Thanks if anyone cah help.
> --David
> *
> *   For searches and help try:
> *
> *
> *
*   For searches and help try:

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