Date:         Tue, 28 Jun 2005 14:17:40 -0400
Reply-To:     "Fehd, Ronald J" <rjf2@CDC.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Fehd, Ronald J" <rjf2@CDC.GOV>
Subject:      SAS Add-In for MS ofc
Content-Type: text/plain; charset="us-ascii"

SAS Add-in for Microsoft Office
-- Leveraging SAS Throughout the Organization from Microsoft Office
http://www2.sas.com/proceedings/sugi29/223-29.pdf

The two wrapper macros for stored procedures are in
C:\Program Files\SAS\SAS 9.1\inttech\sasmacro\stpbegin.sas  567 lines
C:\Program Files\SAS\SAS 9.1\inttech\sasmacro\stpend.sas    221 lines

an example of a Stored Process (program)

%global gender;
%stpbegin; /*initialize ODS processing of output */
proc print data = sashelp.class
where (sex = "&gender");
run;
%stpend; /* terminate ODS processing of output */

the global macro variable gender
must be registered in the SAS metadata of the Stored Process Server.

very interesting concept: type-checking of macro variables.
which is done by Java, (or .Net)

Ron Fehd  the macro maven  CDC Atlanta GA USA RJF2 at cdc dot gov

Your task is simple: remove the difference
between how things should be
and     how they   really are.
-- Ashleigh Brilliant pot-shot #4247

Efficiency is intelligent laziness. -David Dunham