Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: RE: Copying and pasting into Excel


From   Ulrich Kohler <kohler@wz-berlin.de>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: RE: Copying and pasting into Excel
Date   Fri, 5 Dec 2003 09:17:45 +0100

de la Garza, Adrian wrote:
> Yes, I've used StatTransfer and it's certainly very useful. But when I
> need to do quick calculations, it's a lot easier to just cut and paste,
> and I thought it was safe. Is it not? Is there any other way to do this
> quickly besides using StatTransfer?

I don't know whether it is save or not. However you can use -outsheet- if you 
need to transfer data to spreadsheet programs. For example

. outsheet xyz abc using myfile.csv in 1/10, comma

stores the first ten rows of the columns "xyz" and "abc" in the file 
"myfile.csv", which can be readily loaded into spreadsheet programs like 
Excel.

Besides that I am curious which sort of "quick calculations" can be done 
quicker by transfering data and doing the calculations in a spreadsheet 
program instead of just doing the calculations in Stata.

regards
uli

-- 
kohler@wz-berlin.de
+49 (030) 25491-361


*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   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