Date:         Thu, 29 Jun 2006 13:20:42 -0700
Reply-To:     "William W. Viergever" <william@VIERGEVER.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "William W. Viergever" <william@VIERGEVER.NET>
Subject:      Re: Is it possible to run a SAS program in Excel ?
Comments: To: xamil <xaamil@YAHOO.COM>
In-Reply-To:  <20060629050213.68264.qmail@web35103.mail.mud.yahoo.com>
Content-Type: text/plain; charset="us-ascii"; format=flowed

At 10:02 PM 6/28/2006, xamil wrote:
>Hi, folks:
>Is it possible to run a SAS (macro)program imbeded in
>VBA in Excel,


yes ... but think you be better off already haveing a SAS pgm
writtent and simpley call it from w/i Excel

>and run the SAS program by clicking the
>RUN command button created in Excel,

yes


>and output the result in Excel sheets ?

yes ... via DDE, export, Excel libnames, ODS, etc.


>  Could anyone give me a simple example ?

no

:-)

i always go from sas to excel, so am unable to offer an example going
the other way

but

you could code some, i think, OLE, or whatever, stuff to call SAS

better yet, check out the MS Office add-in ... if all you want is to
grab some data in a SAS dataset and get itinto Excel ASAP





---------------------------------------------------
William W. Viergever
Viergever & Associates
Health Data Analysis / Systems Design & Development
Sacramento, CA 95825
william@viergever.net
(916) 483-8398
---------------------------------------------------