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

RE: st: saving .dta files with codes replacing numbers


From   "Charles Thibault" <cthibault@corzen.com>
To   <statalist@hsphsun2.harvard.edu>
Subject   RE: st: saving .dta files with codes replacing numbers
Date   Thu, 12 Jan 2006 11:00:34 -0500

I was having the same problem today...

If you labeled the values, then when outsheeting STATA will outsheet the
labels, not the original values.

The command is

. outsheet using <filename>, replace nolabel 


Hope this solves your problem.

Charles Thibault
www.corzen.com



-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Ulrich Kohler
Sent: Thursday, January 12, 2006 3:20 AM
To: statalist@hsphsun2.harvard.edu
Subject: Re: st: saving .dta files with codes replacing numbers

Wolfgang Polasek wrote:
> When I save the data for exporting it into Excel I get the numerical
> codes and not the string variables as I see them in the data editor.
>
> What should I do to get the the string variables in a spread sheet?

. outsheet using <filename>

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


*
*   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–2021 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index