Re: st: Import Excel Issues

[Stephen <ala.frosty@gmail.com>]

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/