5. FILES › 5.6 UNIX LAN Activity File (AUMNIF) › 5.6.4 AUMNIF Retrieval Examples

5.6.4 AUMNIF Retrieval Examples

The following example provides an overview of LAN activity on
your systems, ranked by LAN traffic.

 %LET BY = SYSID YEAR MONTH DAY NIFNAME;
 %LET BREAK = NIFNAME;
 PROC SORT DATA=DAYS.AUMNIF01 OUT=NIF;
   BY &BY;
 RUN;
 %MACRO NEGATE;
   PKIORT = SUM(NIFPSPKI,NIFPSPKO);
 %MEND;
 DATA NIF;
   SET NIF;
   DATE = DATEPART(ENDTS);
   FORMAT DATE MMDDYY8.;
   %NIFFMT(TS=DAYS,DERV=YES);
   %NIFLBL(DERV=YES);
   %NIFSUM;
 RUN;
 %LET BY = SYSID DATE;
 %LET BREAK = DATE;
 PROC SORT; BY &BY DESCENDING PKIORT;
 DATA NIF2 (KEEP=&BY NIFNAME RANK      NIFPSPKI NIFPSPKO
            NIFPSERR NIFPSCOL)
           ;
   SET NIF;
   BY &BY;
   RETAIN RANK 0;
   IF FIRST.&BREAK THEN RANK = 0;
   RANK+1;
   OUTPUT;
   LABEL RANK = 'Rank';
 RUN;
 PROC PRINT LABEL;
   BY &BY;
   PAGEBY &BREAK;
   ID RANK;
   VAR  NIFNAME NIFPSPKI NIFPSPKO NIFPSERR NIFPSCOL;
   TITLE "Daily LAN Activity Ranked by Traffic";
 RUN;