Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
RE: st: Import excel issues stata12
From
"David Radwin" <[email protected]>
To
<[email protected]>
Subject
RE: st: Import excel issues stata12
Date
Wed, 6 Jun 2012 11:23:36 -0700 (PDT)
Dan,
This is a good tip, and thank you for posting it.
I think it is a very good idea to keep the original Excel files on your
hard drive for various reasons. You can compress them later to save space.
But if for some reason you don't want to keep the Excel files, you can
always -erase- the files after importing the data into Stata.
David
--
David Radwin
Senior Research Associate
MPR Associates, Inc.
2150 Shattuck Ave., Suite 800
Berkeley, CA 94704
Phone: 510-849-4942
Fax: 510-849-0794
www.mprinc.com
> -----Original Message-----
> From: [email protected] [mailto:owner-
> [email protected]] On Behalf Of Dan Blanchette
> Sent: Wednesday, June 06, 2012 10:57 AM
> To: [email protected]
> Subject: Re: st: Import excel issues stata12
>
> I am also not able to get -import excel- to load that Excel file
> until I downloaded it.
>
> Since you are wanting to write a loop, you could use Stata's
> -copy- command:
>
> . copy
>
"http://www.pcr.uu.se/digitalAssets/64/64466_UCDP_DyadicDataset_v12011.xls
> " "C:\data\"
> . import excel using "c:\data\64466_UCDP_DyadicDataset_v12011.xls",
> sheet("UCDP DyadicDataset") firstrow clear
>
> Hope this helps,
> Dan Blanchette
>
> Research Programming Services
> Carolina Population Center
> University of North Carolina
> Chapel Hill, NC 27516 USA
> [email protected]
*
* 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/