Concept, Design

1
SAS Batch Portal
Data Collection and Monitoring Application for
SAS Batch Jobs
Presentation at the Montreal SAS User Group, Sept
28th, 2004

• Concept, Design Programming by Bernard Nicoll,
  CGI (bernard.nicoll_at_cgi.com)

2
Are you faced with the classic case of the W5?

• What is the Status of my Production cycle ?
• Why did my Job(s) fail ?
• When did this happen ?
• Where can I find the SAS Logs/List Outputs ?
• Who has met their completion commitment ?

Well, dont ask me !
Find out for yourself with SAS/BP
3
SAS/BP Features Benefits

• Realtime monitoring of SAS Batch Jobs
• Capture Obs, Vars, Elaps, Lib info, Index, etc.
• Retrieval of Process Script, Pgm, Log, List, ODS
• Metrics (Elaps, Volume Trend, Met, etc.)
• Browse SAS Tables and Attributes
• All features accessible through a Web Browser
• Email/Pager Notification when Job fails
• Program Step Documentation
• Maintenance Support

4
SAS/BP System Architecture
5
Requirements for running SAS/BP

• SAS/Share
• SAS/IntrNet (optional)
• Standardize your Application by defining an
  Environment, a Component, and a Process
• Command Script that calls your SAS Process
• Run Script that defines your SAS Process
  (Libname, Filename, Options, Let etc.)
• The main SAS Program
• The insertion of Macro STEPLOG after each
  Data Step and Procedure in the source program

6
Parameters used by the STEPLOG Macro

• Step give a brief description of the step or
  procedure
• Libref Mem capture Library Member
  information
• ColY capture Variable Attributes (length,
  format, Idx, etc.)
• Fileref capture the information of an external
  file
• Ext_RecsY capture record counts of an external
  file
• AuditY identify this step as part of a critical
  path
• Parm free format field to be displayed in the
  Remarks
• Bypass_ErrorY ignore warnings/errors in the step
• Nobs store the Row count in a macro variable
• Sql_CountY extract Row counts from a DBMS
• Step is the only required parameter, all
  others are optional
• Not required if running the default version
  of SAS/BP

7
SAS/BP Web Interface
8
SAS/BP Application Main Menu
9
Status Detail
10
Library Information
11
Variables Information
12
Job Step Audit View
13
Job History View
14
Job Error/Warnings
15
Process Elaps Time
16
Process
17
Program Step - Details
18
Program Step - Elaps
19
Program Step Volume Trend
20
The Run Script
21
The SAS Program part 1
22
The SAS Program part 2
23
The SAS Program part 3
24
Lets go Live !

• Switching to the Live Demo

25
Oh No !!

• Email to bernard.nicoll_at_cgi.com