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 on April 23, 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 .xls data into STATA


From   Roger Newson <r.newson@imperial.ac.uk>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: import .xls data into STATA
Date   Fri, 23 Sep 2011 15:15:13 +0100

No, you CANNOT download Stat/Transfer for free, unless you want a trial version, which deliberately throws out a few observations in each transfer. Stat/Transfer (like Stata) is proprietary software, and the company (Circle Systems) has to make a living. So, to use a proper Stat/Transfer, which does not throw out observations at random, you have to buy it from its authorized distributors.

To read .xls datasets into Stata wirthout Stat/Transfer, either write the Excel spreadsheet to a generic format (as suggested), or (if you have Stata Version 12) use -import excel-.

Best wishes

Roger


Roger B Newson BSc MSc DPhil
Lecturer in Medical Statistics
Respiratory Epidemiology and Public Health Group
National Heart and Lung Institute
Imperial College London
Royal Brompton Campus
Room 33, Emmanuel Kaye Building
1B Manresa Road
London SW3 6LR
UNITED KINGDOM
Tel: +44 (0)20 7352 8121 ext 3381
Fax: +44 (0)20 7351 8322
Email: r.newson@imperial.ac.uk
Web page: http://www.imperial.ac.uk/nhli/r.newson/
Departmental Web page:
http://www1.imperial.ac.uk/medicine/about/divisions/nhli/respiration/popgenetics/reph/

Opinions expressed are those of the author, not of the institution.

On 23/09/2011 15:08, donsaane wrote:
I think you can do it with stat transfer (you can download it for free)....

-----Message d'origine-----
De : owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] De la part de Muhammad Anees
Envoyé : vendredi 23 septembre 2011 03:02
À : statalist@hsphsun2.harvard.edu
Objet : Re: st: import .xls data into STATA

Save the xls data with .csv extension from file/save as option. Check
that your names are in row 1 of the sheet and conform the stata naming
convention. Then use -insheet using "address of the file on your pc"-

On Fri, Sep 23, 2011 at 10:42 AM, Wu Zhang<wuzhang50@yahoo.com>  wrote:
Hi, folks,
    Could someone help me with importing .xls data into STATA? I tried, but
failed.

Thanks,

Wu


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