Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
| From | "Martin Weiss" <martin.weiss1@gmx.de> |
| To | <statalist@hsphsun2.harvard.edu> |
| Subject | st: AW: load EXCEL to STATA |
| Date | Thu, 1 Apr 2010 09:11:52 +0200 |
<> Stat/Transfer does have facilities to transfer each sheet separately. If you want to run it from Stata, try Roger`s -ssc d stcmd-. HTH Martin -----Ursprüngliche Nachricht----- Von: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von G. Dai Gesendet: Donnerstag, 1. April 2010 05:17 An: statalist@hsphsun2.harvard.edu Betreff: st: load EXCEL to STATA 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/ * * 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/