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

From |
"Martin Weiss" <martin.weiss1@gmx.de> |

To |
<statalist@hsphsun2.harvard.edu> |

Subject |
Re: st: Re: Transfering a large set of Stata tables into Excel |

Date |
Tue, 25 Nov 2008 21:29:52 +0100 |

Example: ************ cap erase mylog.smcl cap erase mylog.log loc files "auto census cancer" log using mylog, name(newlog) replace loc files "auto census cancer" foreach file of loc files{ sysuse `file', clear di in red "`file'" su } log close newlog translate mylog.smcl mylog.log ************ Open mylog.log in your text editor... HTH Martin _______________________

To: <statalist@hsphsun2.harvard.edu> Sent: Tuesday, November 25, 2008 9:25 PM Subject: Re: st: Re: Transfering a large set of Stata tables into Excel

Martin, thanks for the reply.Just -log- your output so you do not have to keep up with Stata`s pace.You can't use the copy table command from the log file though, from what I understand. RachelOn Tue, Nov 25, 2008 at 3:07 PM, Martin Weiss <martin.weiss1@gmx.de>wrote:Just -log- your output so you do not have to keep up with Stata`s pace.See-h log-. I also think -collapse- would serve you well... HTH Martin _______________________ ----- Original Message ----- From: "Rachel" <academicgirl@gmail.com> To: "statalist" <statalist@hsphsun2.harvard.edu> Sent: Tuesday, November 25, 2008 9:03 PM Subject: st: Transfering a large set of Stata tables into ExcelI'm performing the -su- command on a series of variables in each of a large set of datasets. The command looks like global Datasets "dataset1 dataset2....dataset35" foreach l in $Datasets { use `l' di in red "`l'" su var1-var3 var8-var11 var17-var25 clear } I need to transfer all the resultant tables (maybe 35 of them) into Excel. From what I understand, the Copy Table right-click command only works on a single table at a time , so I have to copy them one by one, correct? But because the running display only stores up to a certain number of lines, I have to do it as the command is running. Is there another better way to transfer all these tables into Excel than copying and pasting them one by one? Thanks very much, Rachel * * 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/

**References**:**st: Transfering a large set of Stata tables into Excel***From:*Rachel <academicgirl@gmail.com>

**st: Re: Transfering a large set of Stata tables into Excel***From:*"Martin Weiss" <martin.weiss1@gmx.de>

**Re: st: Re: Transfering a large set of Stata tables into Excel***From:*Rachel <academicgirl@gmail.com>

- Prev by Date:
**st: hist with addplot option** - Next by Date:
**Re: st: hist with addplot option** - Previous by thread:
**Re: st: Re: Transfering a large set of Stata tables into Excel** - Next by thread:
**Re: st: Transfering a large set of Stata tables into Excel** - Index(es):

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