this may be easy enough to just do with outsheet and proc import,
avoiding the Excel step:
. sysuse auto.dta
(1978 Automobile Data)
. outsheet using auto.txt
In SAS:
proc import datafile="C:\data\auto.txt"
out=auto
dbms=tab
replace;
getnames=yes;
run;
On 1/11/07, juzhi wang <[email protected]> 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/
*
* 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/
