Statalist


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

Re: st: RE: how to save output from TABLE or TABSTAT as a stata .dta data file


From   "Martin Weiss" <martin.weiss1@gmx.de>
To   <statalist@hsphsun2.harvard.edu>
Subject   Re: st: RE: how to save output from TABLE or TABSTAT as a stata .dta data file
Date   Thu, 9 Apr 2009 00:13:11 +0200

<>

Of course, you could also specify the -replace- option with -table-

****
sysuse auto, clear
table rep78, contents(sum headroom ) row replace
l
****

Also look at -ssc d tabout-


BTW, out of curiosity, how does -collapse- create trouble when "some of the data generated is empty"?



HTH
Martin
_______________________
----- Original Message ----- From: <fengsz@yahoo.com>
To: <statalist@hsphsun2.harvard.edu>
Sent: Wednesday, April 08, 2009 10:46 PM
Subject: Re: st: RE: how to save output from TABLE or TABSTAT as a stata .dta data file


Thank you Both, Martin and Albert. But I was trying to avoid using collapse as it creates trouble when the some of the data generated is empty. Is there anyway to save the output from table or tabstat, or it's simply not possible?

Shuaizhang

--- On Wed, 4/8/09, Lee, Albert <Albert.Lee@hud.gov> wrote:

From: Lee, Albert <Albert.Lee@hud.gov>
Subject: st: RE: how to save output from TABLE or TABSTAT as a stata .dta data file
To: statalist@hsphsun2.harvard.edu
Date: Wednesday, April 8, 2009, 2:58 PM
This may not be elegant, but try:

preserve

collapse (sum) b, by(a)

save filename, replace

restore

I hope it helps.

Albert.

Albert J. Lee, Ph.D
Economist
Summit Consulting LLC
albert.lee@hud.gov
(202) 402 7562



-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu]
On Behalf Of Shuaizhang
Feng
Sent: Wednesday, April 08, 2009 2:51 PM
To: statalist@hsphsun2.harvard.edu
Subject: st: how to save output from TABLE or TABSTAT as a
stata .dta
data file

Dear all:

I am wondering if anyone knows how to save table output
from TABLE or
TABSTAT to a stata data file.

For example, I have used

. table a, c(sum b)

to generate a list of summary statistics:


a sum(b)

1 19372
2 102820
3 21403
4 19001
5 82549
6 15664
7 83616
8 50149


How do I save this and maybe change the name of the two
variables for
later use.

Thank you very much.

Shuaizhang



*
* 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