1 / 25

Concept, Design & Programming by Bernard Nicoll , CGI ( bernard.nicoll@cgi )

SAS Batch Portal. Data Collection and Monitoring Application for SAS Batch Jobs. Concept, Design & Programming by Bernard Nicoll , CGI ( bernard.nicoll@cgi.com ). Presentation at the Montreal SAS User Group, Sept 28 th , 2004. Are you faced with the classic case of the ‘ W5 ’ ?.

chun
Download Presentation

Concept, Design & Programming by Bernard Nicoll , CGI ( bernard.nicoll@cgi )

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SAS Batch Portal Data Collection and Monitoring Application for SAS Batch Jobs Concept, Design & Programming by Bernard Nicoll,CGI (bernard.nicoll@cgi.com) Presentation at the Montreal SAS User Group, Sept 28th, 2004

  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, don’t 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 • Col=Y capture Variable Attributes (length, format, Idx, etc.) • Fileref= capture the information of an external file • Ext_Recs=Y capture record counts of an external file • Audit=Y identify this step as part of a critical path • Parm= free format field to be displayed in the Remarks • Bypass_Error=Y ignore warnings/errors in the step • Nobs= store the Row count in a macro variable • Sql_Count=Y 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. Let’s go Live ! Switching to the Live Demo…

  25. Oh No … !! Email to bernard.nicoll@cgi.com

More Related