Statalist


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

Re: st: pasting from excel into Stata 11


From   Sergiy Radyakin <serjradyakin@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: pasting from excel into Stata 11
Date   Mon, 2 Nov 2009 14:11:58 -0500

Dear Al!
It seems that the empty columns cause this problem. For the sheets
without them, there is a message, which asks how to interpret the
first line.
Stata 9 and 10 had different behavior, and automatically named the
empty column with a varNN name.
You can still save to the CSV file and insheet it in Stata, though it
is a bit less convenient.
Best,
    Sergiy Radyakin


On Mon, Nov 2, 2009 at 10:32 AM, Feiveson, Alan H. (JSC-SK311)
<alan.h.feiveson@nasa.gov> wrote:
> 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/
>

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