Statalist


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

st: pasting from excel into Stata 11


From   "Feiveson, Alan H. (JSC-SK311)" <alan.h.feiveson@nasa.gov>
To   "statalist@hsphsun2.harvard.edu" <statalist@hsphsun2.harvard.edu>
Subject   st: pasting from excel into Stata 11
Date   Mon, 2 Nov 2009 09:32:54 -0600

Stata IC 11: Windows XP -

I often get data in the form of Excel (MS Office 2007) spreadsheets. In the past I could usually paste such data directly into the Stata Editor with the first row as variable names and depending on the first row after that, variables would be designated as string or real, usually correctly. Now with Stata 11, for some excel sheets (I don't know why), I do not get the message asking about whether the first row is names or data. Instead all variables are treated as strings even if they are all numbers (even those having the "Number" format in Excel). It appears as though Stata is treating the first row as data even though they are names. There also seems to be something about blank columns in the spreadsheet that causes this behavior. Is there some setting in Stata 11 which will change this behavior. It is most annoying.

My apologies for probably asking what has probably been asked before, but I can't seem to find this issue directly addressed on the Statalist archives or the manuals.

AL Feiveson

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