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
Wu Zhang <[email protected]>
To
"[email protected]" <[email protected]>
Subject
Re: st: import .xls data into STATA
Date
Sat, 24 Sep 2011 15:39:53 -0700 (PDT)
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/