Bookmark and Share

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 .xls data into STATA


From   Alex Olssen <[email protected]>
To   [email protected]
Subject   Re: st: import .xls data into STATA
Date   Mon, 26 Sep 2011 10:12:12 +1200

If you want to use an external program to do the conversion then R is FREE.

The package  foreign()  can read in .xls files and write out .dta files.

On 25 September 2011 10:39, Wu Zhang <[email protected]> wrote:
> Thank you all!
> ----- Original Message -----
> From: Roger Newson <[email protected]>
> To: [email protected]
> Cc:
> Sent: Friday, September 23, 2011 10:15 AM
> Subject: Re: st: import .xls data into STATA
>
> 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: [email protected]
> 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 : [email protected]
>> [mailto:[email protected]] De la part de Muhammad Anees
>> Envoyé : vendredi 23 septembre 2011 03:02
>> À : [email protected]
>> 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<[email protected]>  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/
>
>
> *
> *   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–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index