5. FILES › 5.2 WEB Information Area (WEB) Files › 5.2.10 Web Request Activity File (WEBWRA) › 5.2.10.4 WEBWRA Retrieval Examples

5.2.10.4 WEBWRA Retrieval Examples

 
 This section presents a typical WEBWRA retrieval example.
 
    Produce summary reports showing the web request activity
    for applications running in a server of a cluster by
    request type.
 
    PROC SORT DATA=&WEBD..WEBWRA01 OUT=TEMP;
      BY WEBSRVNM WEBINAME WEBRTYPE;
    RUN;
 
    DATA TEMP;
      SET TEMP;
        BY WEBSRVNM WEBINAME WEBRTYPE;
        %WRASUM;
    END;
    RUN;
 
    PROC PRINT DATA=TEMP LABEL;
      ID WEBSRVNM WEBINAME WEBRTYPE;
      VAR WRAREQST WRAPRQTM WRAQTM WRADSPTM WRATRSTM WRAVTTM
          WRAPCGMT;
      TITLE 'Web Request Response Time Report';
    RUN;
 
    PROC PRINT DATA=TEMP LABEL;
      ID WEBSRVNM WEBINAME WEBRTYPE;
      VAR WRAREQST WRACPUTM WRAXCSTM WRASUPTM WRASPNTM
          WRASUCTM WRAZAPTM WRAZPNTM WRAZACTM;
      TITLE 'Web Request CPU Usage Report';
    RUN;