Re: st: from stata to SAS

[juzhi wang <juzhi_1@yahoo.ca>]

I have listened to Rodrigo's advice. And I did export my stata file into excel. But one of the data file has too many variables and I am not allowed to do completely transfer ( I guess the number of variables has exceeded the Excel limit). Only about half of the varialbes have been transfered. Could anybody give me further advice?

Thanks,

----- Original Message ----
From: Rodrigo Martell <rodrigo.martell@frontier-economics.com.au>
To: statalist@hsphsun2.harvard.edu
Sent: Friday, January 12, 2007 2:01:01 AM
Subject: RE: st: from stata to SAS


Hi Juzhi,

A free alternative to Michael's suggestion (I think you have to pay for StatTransfer):

I don't know anything about SAS but I assume it can read in csvs (?).

If so then an easy way would be to open the Stata file you're interested in and type this (I'll send it to your C drive):

outsheet using "C:\Stata_to_Sas.csv", comma replace


The above will spit out a csv file which Excel can read, but if SAS reads csvs you could just skip the Excel bit and go straight to SAS.
How many Stata files do you need to translate? 
If you need to do more than would be feasible for manual typing of the above suggestion you could create a do file
(in Stata, click on the toolbar icon with a little hand and a pencil over a piece of paper), copy and paste the below code and run it by clicking either of the buttons with the downward pointing arrows. 
In the code below I assumed you have 2 files (stata1.dta and stata2.dta) you want to spit out as csvs. The path where these files live I assumed to be "C:/", you can change the path (leave in the quotation marks and make sure the last slash before `name' is a forward slash, the rest can be either back or forward, Stata understands both e.g C:/MyFolder/MySecondFolder/ = C:\MyFolder\MySecondFolder/).

------Copy from line below
capture program drop stata_sas
program define stata_sas
syntax namelist
foreach name of local namelist{
    use "C:/`name'.dta", clear
    outsheet using "C:/`name'.csv", comma replace
}
end

stata_sas stata1 stata2
----end copy at above line

If you want to add more Stata files just add the names of the files to the last line of the code.

I hope this is of some help.

Cheers,

Rodrigo 

Rodrigo Martell

<http://www.frontier-economics.com>     
Frontier Economics Pty. Ltd.
395 Collins Street
Melbourne VIC 3000
Australia
www.frontier-economics.com     
switch:
direct:
fax:
mobile:
email:


+61 (0)3 9620 4488
+61 (0)3 9613 1518
+61 (0)3 8614 2711
+61 (0)407 909 811
rodrigo.martell@frontier-economics.com <mailto:rodrigo.martell@frontier-economics.com> 


This e-mail, including any attachments, may contain confidential and privileged information for the sole use of the intended recipient(s). Any review, use, disclosure or distribution by others is strictly prohibited. If you are not the intended recipient (or authorised to receive information for the recipient), please contact the sender by reply e-mail and delete all copies of this message. Thank you.

    



-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu]On Behalf Of Michael
McCulloch
Sent: Friday, 12 January 2007 4:41 PM
To: statalist@hsphsun2.harvard.edu
Subject: Re: st: from stata to SAS


Juzhi,
A software called Stat-transfer can do this without any SAS -or Stata- code.
(http://www.stattransfer.com/).
Michael





At 08:25 PM 1/11/2007, you wrote:
>Hello Everybody:
>
>I am a SAS user. I do not know anything about Stata. But I need to import 
>Stata data sets to SAS. What I need to do is to export the Stata into 
>Excel and from Excel to SAS. Could anybody in the list provide a block of 
>code to help me export the Stata dataset to Excel?
>
>Thanking you very much in advance,
>Juzhi
>
>__________________________________________________
>Do You Yahoo!?
>Tired of spam?  Yahoo! Mail has the best spam protection around
>http://mail.yahoo.com
>
>*
>*   For searches and help try:
>*   http://www.stata.com/support/faqs/res/findit.html
>*   http://www.stata.com/support/statalist/faq
>*   http://www.ats.ucla.edu/stat/stata/


Best wishes,
Michael


____________________________________

Michael McCulloch
Pine Street Clinic
Pine Street Foundation
124 Pine Street, San Anselmo, CA 94960-2674
tel     415.407.1357
fax     415.485.1065
email:  mm@pinest.org
web:    www.pinest.org
         www.pinestreetfoundation.org
         www.medepi.net/meta





*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/

*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/


      Be smarter than spam. See how smart SpamGuard is at giving junk email the boot with the All-new Yahoo! Mail at http://mrd.mail.yahoo.com/try_beta?.intl=ca


*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/