Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down on April 23, and its replacement, statalist.org is already up and running.


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

Re: st: Import Excel Issues


From   Stephen <ala.frosty@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: Import Excel Issues
Date   Sat, 24 Sep 2011 18:02:22 -0400

I'm not using Stata 12, so I can't check your problem, however, I can
suggest that if you save the Excel sheet you need as a .CSV (comma
separated values) file, Stata should read it in without complaining.

Note: You may need to change all the number formats from "general" to
"number" otherwise Excel (usually) includes commas in the output of
numbers over 999 which can really mess up the CSV file.

Stephen




On Sat, Sep 24, 2011 at 1:16 PM, William Buchanan
<william@williambuchanan.net> wrote:
> Hello,
>
> I was just wondering if any folks have run into any issues with the -import excel- command?  I'm running Stata 12MP (updated up to 15 SEP 2011) on a MAC with OSX 10.5 (Snow Leopard).  I tried using the abbreviated form of the command (i.e., - import exc -) and received an error:
>
> import exc using "/Users/billy/Desktop/NEW BROCKTON/brockton-2011.xlsx", first
> import: unknown subcommand "exc"
> r(198);
>
> I used the unabbreviated version of the command and didn't receive any errors, but it didn't correctly import the data (i.e., tons of missing data was present and no variable names were loaded).  I thought it may have been a problem with using the  - first - option, so I ran it again without this option and the data still loaded the same way.
>
> I haven't tried to replicate the issue with any of the Stata data sets, but didn't know if others were having any issues with this.
>
> Thanks,
> Billy Buchanan
> *
> *   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   |   Site index