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 at the end of May, 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   William Buchanan <william@williambuchanan.net>
To   "statalist@hsphsun2.harvard.edu" <statalist@hsphsun2.harvard.edu>
Subject   Re: st: Import Excel Issues
Date   Sat, 24 Sep 2011 15:11:58 -0700

Hi Stephen, 

I ended up converting it, but wanted to try giving the new function a whirl.  Unfortunately it didn't work out so well. Then I remembered that I have StatTransfer and just used that instead.

Thanks again,
Billy

Sent from my iPhone

On Sep 24, 2011, at 15:02, Stephen <ala.frosty@gmail.com> wrote:

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

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