1 / 14

Transferring Data into Stata F rom Microsoft Excel or Access

Transferring Data into Stata F rom Microsoft Excel or Access. Nathan Favero June 7, 2013. Transferring Data from Excel to Stata. Microsoft Excel 2010. Transferring Data from Excel to Stata. Delete Extra Rows. Transferring Data from Excel to Stata. Save As.

ghada
Download Presentation

Transferring Data into Stata F rom Microsoft Excel or Access

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Transferring Data into StataFrom Microsoft Excel or Access Nathan Favero June 7, 2013

  2. Transferring Data from Excel to Stata Microsoft Excel 2010 Transferring Data into Stata

  3. Transferring Data from Excel to Stata Delete Extra Rows Transferring Data into Stata

  4. Transferring Data from Excel to Stata Save As Transferring Data into Stata

  5. Transferring Data from Excel to Stata Select “Text” or “CSV” Transferring Data into Stata

  6. Transferring Data from Excel to Stata Select “OK” and then “Yes” Transferring Data into Stata

  7. Transferring Data from Excel to Stata Change Directory (This tells Stata what folder to look in.) Filename This tells Stata that the first row of the document contains variable names. Use this command to read in comma- or tab-delimited files. Transferring Data into Stata

  8. Transferring Data from Access to Stata Microsoft Access 2010 Transferring Data into Stata

  9. Transferring Data from Access to Stata • External Data  Text File (Export) Transferring Data into Stata

  10. Transferring Data from Access to Stata • Select a file location and name. Click OK. Transferring Data into Stata

  11. Transferring Data from Access to Stata • Click Next. Transferring Data into Stata

  12. Transferring Data from Access to Stata • Select “Include Field Names on First Row.” • Click Finish. Transferring Data into Stata

  13. Transferring Data from Access to Stata • Click Close. Transferring Data into Stata

  14. Transferring Data from Access to Stata Change Directory (This tells Stata what folder to look in.) Filename This tells Stata that the first row of the document contains variable names. Use this command to read in comma- or tab-delimited files. Transferring Data into Stata

More Related