Date:         Wed, 25 Jan 2006 21:21:57 -0500
Reply-To:     Wensui Liu <liuwensui@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Wensui Liu <liuwensui@GMAIL.COM>
Subject:      Re: SAS to Excel
Comments: To: Jiann-Shiun Huang <Jiann-Shiun.Huang@amerus.com>
In-Reply-To:  <s3d7dcfa.053@mail6.amerus.com>
Content-Type: text/plain; charset=ISO-8859-1

you can find plenty on support.sas.com.

on my blog, you also can find a couple examples.

On 1/25/06, Jiann-Shiun Huang <Jiann-Shiun.Huang@amerus.com> wrote:
>
> Wensui:
>
>   Could you point me to some reference?  Thanks,
>
> J S Huang
> 1-515-557-3987
> fax 1-515-557-2422
>
> >>> Wensui Liu <liuwensui@gmail.com> 1/25/2006 8:16:34 PM >>>
> take a look at DDE.
>
> On 1/25/06, Jiann-Shiun Huang <Jiann-Shiun.Huang@amerus.com> wrote:
> >
> > Art:
> >
> >   Unfortunately I do not have SAS/ACCESS although I do have SAS9.
> >
> > J S Huang
> > 1-515-557-3987
> > fax 1-515-557-2422
> >
> > >>> Arthur Tabachneck <art297@NETSCAPE.NET> 1/25/2006 8:12:47 PM >>>
> > Jiann,
> >
> > If you have SAS9, and SAS/ACCESS software for PC file formats, you
> > could
> > use Proc Export.  Take a look at:
> >
> > http://support.sas.com/onlinedoc/912/getDoc/proc.hlp/a000393175.htm
> >
> > Art
> > ---------
> > On Wed, 25 Jan 2006 19:18:19 -0600, Jiann-Shiun Huang <Jiann-
> > Shiun.Huang@AMERUS.COM> wrote:
> >
> > >Window XP Professional
> > >
> > >J S Huang
> > >1-515-557-3987
> > >fax 1-515-557-2422
> > >
> > >>>> Wensui Liu <liuwensui@GMAIL.COM> 1/25/2006 7:15:07 PM >>>
> > >which OS are you using?
> > >
> > >On 1/25/06, J S Huang <jiann-shiun.huang@amerus.com> wrote:
> > >>
> > >> SAS-L:
> > >>
> > >>   Here are questions on exporting SAS tables to Excel:
> > >>
> > >> (1) Can I export more than one table to different worksheets of
> an
> > >Excel
> > >> file?
> > >>
> > >> (2) Can I name the worksheet to which a table is exported?
> > >>
> > >> (3) It seems that using code like the following is somewhat slow.
> > >Is
> > >> there better alternative?
> > >>
> > >>     Ods listing close;
> > >>     Ods tagsets.ExcelXP file="C:\Air.xls";
> > >>     Proc print data=Triton.&&block&i noobs;
> > >>     Run;
> > >>     Ods tagsets.ExcelXP close;
> > >>     Ods listing;
> > >>
> > >>
> > >>   TIA
> > >>
> > >>   J S Huang
> > >>
> > >
> > >
> > >
> > >--
> > >WenSui Liu
> > >(http://statcompute.blogspot.com)
> > >Senior Decision Support Analyst
> > >Health Policy and Clinical Effectiveness
> > >Cincinnati Children Hospital Medical Center
> >
>
>
>
> --
> WenSui Liu
> (http://statcompute.blogspot.com)
> Senior Decision Support Analyst
> Health Policy and Clinical Effectiveness
> Cincinnati Children Hospital Medical Center
>



--
WenSui Liu
(http://statcompute.blogspot.com)
Senior Decision Support Analyst
Health Policy and Clinical Effectiveness
Cincinnati Children Hospital Medical Center