5. FILES › 5.3 Web Log Information Area (WLG) Files › 5.3.7 HTTP Access Path Summary (WLGAPS) File › 5.3.7.4 WLGAPS Retrieval Examples

Previous Topic: 5.3.7.3 WLGAPS Usage Considerations

Next Topic: 6. DATA SOURCES

5.3.7.4 WLGAPS Retrieval Examples


This section presents a typical WLGAPS retrieval example.

 List the top twenty web pages accessed for each server.

  PROC SORT DATA=&PWEBD..WLGAPS01 OUT=WLGAPS01;
   BY WEBIP WEBPORT APSPATH;

  PROC SUMMARY DATA=WLGAPS01 NWAY;
    CLASS WEBNAME APSPATH ;
    VAR APSACNT APSACCNT APSPCNT APSPCCNT;
    OUTPUT OUT=NEW SUM=APSACNT APSACCNT APSPCNT APSPCCNT;
  RUN;

  OPTIONS OBS=20;

  PROC PRINT;
    ID WEBNAME APSPATH ;
    VAR APSACNT APSACCNT APSPCNT APSPCCNT;
  RUN;