Date: Wed, 4 Aug 2010 00:19:58 -0700
Reply-To: ajay ohri <ajayohri@YAHOO.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: ajay ohri <ajayohri@YAHOO.COM>
Subject: Re: Excel frontend with SAS engine
In-Reply-To: <057601cb3393$8228eb80$867ac280$@savian.net>
Content-Type: text/plain; charset=iso-8859-1
I remember doing something similar some years ago
It is a three step process.
1) Create SAS code with DDE to open Excel file with specific name/location and input in values from specific cells as parameters.
2) Create Batch file for running this SAS file
3) Create VBA form to input parameters into specific locations (same as step1) - and denote them with parameter names
At end of code, call batch file (step2)
A simpler step is to modify sas code to just import the whole excel file using proc import, and then use specific values based on column names (or VarX) and row values (n=a) to input the parameters.
Its not very elegant and may be slow but will get the job done
http://decisionstats.wordpress.com
"If you have the guts, you will have the glory"
--- On Wed, 8/4/10, Alan Churchill <alan.churchill@SAVIAN.NET> wrote:
> From: Alan Churchill <alan.churchill@SAVIAN.NET>
> Subject: Re: Excel frontend with SAS engine
> To: SAS-L@LISTSERV.UGA.EDU
> Date: Wednesday, August 4, 2010, 10:41 AM
> There are lots of ways of doing this.
> It also depends on where SAS is
> located. SAS has 3 providers:
>
> Local
> Int Tech
> Share
>
> You can also do it using SAS/IntrNet and using other means
> but you hit
> license restrictions even if there are other technical
> approaches. I have
> done all of them except Share but it is probably the least
> popular way. SOAP
> and REST web services work great but it depends on what you
> have.
>
> Decide on what you want to use for the UI then build the
> interface. Once
> that is in place, you then place the SAS call.
>
> The OP does not say what he is using or where SAS is
> located. More details
> and I can pass some code.
>
> I am unsure whether I have VBA code for doing what you want
> but I might. I
> dislike VBA so I may not have kept any around. That said,
> it is easy to
> translate C# and you really should use that approach anyway
> rather than VBA.
> Explain the architecture and what you are trying to
> accomplish and it will
> help a lot. Do you want a button in Excel that a user
> clicks and does this
> or do you merely want SAS data in Excel? Stuff like that
> will help with the
> approach. Putting SAS data into Excel, if done right using
> .NET, can be 200x
> faster than a VBA approach. YMMV.
>
> Alan
>
> Alan Churchill
> Savian
> Work: 719-687-5954
> Cell: 719-310-4870
>
>
> -----Original Message-----
> From: Arthur Tabachneck [mailto:art297@NETSCAPE.NET]
> Sent: Tuesday, August 03, 2010 4:17 PM
> Subject: Re: Excel frontend with SAS engine
>
> Shaheen,
>
> Take a look at: http://www2.sas.com/proceedings/sugi30/157-30.pdf
>
> HTH,
> Art
> -----------
> On Aug 3, 2:16 pm, Shaheen <siqu...@gmail.com>
> wrote:
> > On Aug 3, 11:52 am, Ya <huang8...@gmail.com>
> wrote:
> >
> >
> >
> >
> >
> > > On Aug 3, 9:03 am, Shaheen <siqu...@gmail.com>
> wrote:
> >
> > > > Hi,
> > > > I want to use an excel frontend to create a
> UI. Once I select all
> > > > the parameters, I want to call a SAS program
> by clicking a button
> > > > on excel that will take these parameters,
> executes SAS Program
> > > > (stored some where on my machine) and then
> return the resulting
> dataset.
> >
> > > > How can I achieve this?
> >
> > > > Anyone with a sample spreadsheet and sample
> sas code?
> >
> > > SAS Integration Technology is what you need.
> > > You can find many samples by goolging the key
> word "SAS Integration
> > > Technology Excel".
> > > Here is one "http://www.dartmouth.edu/~bburnham/tdi/
> > > SAS_Integration.ppt"
> >
> > > You may need some experience on VB, C# etc.
> >
> > > HTH
> >
> > > Ya
> >
> > Thanks... but the example in the above website does
> not show how to
> > call a stored SAS program and execute it through VBA.
> I have gone
> > through most of the stuff on this website before but
> still not able to
> > solve the issue at hand.- Hide quoted text -
> >
> > - Show quoted text -
>
| 
