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]
st: load EXCEL to STATA
From
"G. Dai" <[email protected]>
To
[email protected]
Subject
st: load EXCEL to STATA
Date
Wed, 31 Mar 2010 20:16:53 -0700
hi all,
I have a very big data set which is consist of hundreds of smaller
EXCEL table sheet.
Each EXCEL table sheet actually includes many county observations in one state.
To read the EXCEL in my STATA, I need first OPEN the EXCEL file and then SAVE it
as CSV form. However, this easy task seems very time consuming since
hundreds of
such sheet need to be open and save!
So, is there any easy to read the EXCEL sheet without saving it into CSV form?
Last, the EXCEL sheet actually includes a title and short description
notes at the
beginning of the sheet, which is very annoying.
Any suggestions are appreciated.
Regards,
Guang
*
* 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/