Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
st: Strings dropped when importing Excel file
From
Friedrich Huebler <[email protected]>
To
[email protected]
Subject
st: Strings dropped when importing Excel file
Date
Fri, 8 Nov 2013 13:23:33 -0500
I use Stata 12.1. When importing an Excel file with string variables
(cell format "Text"), the variables are correctly imported as strings
but the following entries are replaced by empty cells in Stata:
#N/A
#VALUE!
Is it possible to keep these strings? I found no information on this
in the documentation for -import excel-. The -allstring- option makes
no difference.
Thanks,
Friedrich
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/faqs/resources/statalist-faq/
* http://www.ats.ucla.edu/stat/stata/