5. FILES › 5.3 UNIX Application Performance File (AUMAPP) › 5.3.4 AUMAPP Retrieval Examples

5.3.4 AUMAPP Retrieval Examples

Print the use of CPU, memory, and swap spaces for the top ten
applications on the system.

 %LET BY = SYSID YEAR MONTH DAY AUMAPU;
 %LET BREAK = AUMAPU;
 PROC SORT DATA=DAYS.AUMAPP01 OUT=APP;
   BY &BY;
   RUN;
 DATA APP;
   SET DAYS.AUMAPP01;
   DATE = DATEPART(ENDTS);
   FORMAT DATE MMDDYY8.;
   SET APP;
   %APPFMT(TS=DAYS,DERV=YES);
   %APPSUM;
 RUN;
 %LET BY = SYSID DATE;
 %LET BREAK = DATE;
 PROC SORT; BY &BY DESCENDING APPCPUTM;
 DATA APP2 (KEEP=&BY AUMAPU APPPCCPU APPCPUTM APPPCUSR
            APPPCNIC APPPCSYS APPPCRTM
            APPAVAPR RANK);
   SET APP;
   BY &BY;
   RETAIN RANK 0;
   IF FIRST.&BREAK THEN RANK = 0;
   RANK+1;
   IF RANK > 10 THEN RETURN;
   OUTPUT;
   LABEL RANK = 'Rank'
         AUMAPU   = 'Application*Name'
         APPPCCPU = '%CPU Use*Total'
         APPCPUTM = 'Total*CPU Use'
         APPPCUSR = '%CPU Use*User Mode'
         APPPCNIC = '%CPU Use*Nice'
         APPPCSYS = '%CPU Use*System'
         APPPCRTM = '%CPU Use*Real Time'
         APPAVAPR = 'Avg Process*Active'
         ;
 RUN;
 PROC PRINT SPLIT='*';
   BY &BY;
   PAGEBY &BREAK;
   ID RANK;
   VAR  AUMAPU APPCPUTM APPAVAPR APPPCCPU APPPCUSR APPPCNIC
        APPPCRTM APPPCSYS;
   TITLE "Top 10 Applications by CPU Use";
 RUN;