5. FILES › 5.3 VMX Information Area Files › 5.3.16 VMX Shared Storage Management File (VMXXSS) › 5.3.16.4 VMXXSS Retrieval Examples

5.3.16.4 VMXXSS Retrieval Examples

List all saved systems in the VMXXSS file and the average
number of users accessing each system.

   %VMCBRK(FILE=VMXXSS01,PERIOD=15);
   RUN;
   DATA SAVSYS(KEEP=SYSID DATE TIME
               XSSNAME INTERVLS AVGNSH AVGSHR);
     SET VMXXSS; BY SYSID DATE XSSNAME TIME;
     IF FIRST.TIME THEN DO;
       Z1=0;Z2=0;Z3=0;
     END;
     Z1+XSSSHRCT;
     Z2+XSSNSHCT;
     Z3+INTERVLS;
     IF LAST.TIME
     THEN DO;
       AVGSHR = Z1/Z3; AVGNSH = Z2/Z3;
       INTERVLS = Z3;
       OUTPUT;
     END;
   RETURN;
   PROC PRINT SPLIT='*';
     BY SYSID;
     ID XSSNAME;
     PAGEBY SYSID;
     LABEL AVGSHR='Avg. Users In* Shared Mode'
           AVGNSH=' Avg. Users In *Non-Shared Mode'
           DATE='Date' Time='Time'
           XSSNAME='Saved System*    Name'
           INTERVLS='Interval* Count';
      TITLE "Saved System Access Summary";
   RUN;