Ted Stolarczyk, Systems Engineer SAS Customer Loyalty & Retention team

The content of this presentation represents SAS Institute Inc. and should not be interpreted as an endorsement on behalf of CMS. The opinions expressed do

not reflect the views of the Centers for Medicare & Medicaid Services, the Department of Health and Human Services, nor the United States government.

Re-using and Re-purposing your SAS programs via the

SAS Stored Process concept

The benefits of “re-use” and “re-purpose”

SAS Program

What is a SAS Stored Process?

– is a SAS program that is hosted on a server and described by metadata

– can be executed by ANY SAS client capable of interacting with the SAS Metadata Server repository (e.g. Web Report Studio/MS Office)

– can be executed by certain non-SAS technology components capable of interacting with the SAS Metadata Server repository (e.g. MS-Sharepoint)

– can be thought of a SAS “Shared Process”

– is capable of running SAS data access, data manipulation, analytics, business intelligence & reporting capabilities

SAS Stored Process versus Traditional SAS Macro Code

Re-use and Re-purpose for

yourself or anybody who shares

your Enterprise Guide project

Why SAS Enterprise Guide (EG) is the de facto standard for building/deploying re-use and re-purpose

Re-use and Re-purpose for

your ultimate SAS end user community at large

(e.g. MS Office, web browser, etc.)

Prompts available to the EG SAS (aka BI Content) Developer • Text

• Text Range

• Hyperlink

• Numeric

• Numeric Range

• Date

• Date Range

• Time

• Time Range

• Timestamp

• Timestamp Range

• Data Source

• Data Source Item

• File or Directory

• Color

• Data Library

• Variable

http://support.sas.com/resources/papers/proceedings11/309-2011.pdf

SAS will auto-”magically” render appropriately for the end user regardless of interface (AMO, WRS, etc.)

The process for utilizing these “special” macros (~ Dev/Test)…

The process for utilizing these “special” macros (~ PROD)…

VERSUS

10

EG Stored Process deployer – It steps you through – 1 of 7

11

EG Stored Process deployer – It steps you through – 2 of 7

12

EG Stored Process deployer – It steps you through – 3 of 7

13

EG Stored Process deployer – It steps you through – 4 of 7

14

EG Stored Process deployer – It steps you through – 5 of 7

15

EG Stored Process deployer – It steps you through – 6&7 of 7

16

End user “Prompt experience” versus the Developer’s

Overseer/”Traffic Cop” for anything Stored Process related within SAS

Central place to

view/manage all SAS

Stored Process

Technical Metadata

Central place to

view/manage all SAS

Stored Process

Business Metadata

SAS “Prompted Processes” Live Demonstration

18

Tips/Tricks, Best Practices, Examples, Tutorials, and the like on this topic

19

http://lexjansen.com/search/searchresults.php?cx=01124085795099

1443104%3Ahsqcj3nokh0&q=%22Enterprise+Guide%22+%22Prom

pt%22+%22Stored+Process%22&sa=Search&as_filetype=pdf&cof=F

ORID%3A9#1200

Question from Audience … What If I’m Running Older Releases of EG?

• What’s New in SAS EG v4.3:

http://support.sas.com/documentation/cdl/en/whatsnew/62580/HTML/default/viewer.htm#egwhatsnew43.htm

• What’s New In SAS EG v4.2:

http://support.sas.com/documentation/cdl/en/whatsnew/62580/HTML/default/viewer.htm#egwhatsnew42.htm

• What’s New In SAS EG v4.1:

http://support.sas.com/documentation/whatsnew/91x/eg41whatsnew.htm

20

Ted Stolarczyk, Systems Engineer SAS Customer Loyalty & Retention team

The content of this presentation represents SAS Institute Inc. and should not be interpreted as an endorsement on behalf of CMS. The opinions expressed do

not reflect the views of the Centers for Medicare & Medicaid Services, the Department of Health and Human Services, nor the United States government.

Thank You for being a Valuable

SAS customer