How MSU and MIPS Columns Are Included in Staged Tables for the SMF Adapter

/* Read the Microsoft Excel workbook that contains extracted information 
from IBM LSPR documentation and create a SAS data set from it. */ 

PROC IMPORT OUT=WORK.LSPRDATA  
     DATAFILE=<"location-of-spreadsheet">
     DBMS=EXCEL REPLACE;
     SHEET="Sheet1$"; 
 	    GETNAMES=NO;
     MIXED=NO; 
     SCANTEXT=YES; 
     USEDATE=YES;  
     SCANTIME=YES;
 RUN;
 
/* Extract selected fields of information from the vendor-supplied 
LSPR resource information. */

DATA WORK.LSPRDATA(keep=CPCFMODL LSPRCPUS LSPRPCI LSPRMSU);
    SET WORK.LSPRDATA;
  	 LENGTH CPCFMODL $ 8; 
 		 IF _n_=1 THEN DELETE;
  	 CPCFMODL=F1; 
 		 LSPRCPUS=F2; 
 		 LSPRPCI=F3;
  	 LSPRMSU=F4; 
run; 

/* Store IBM LSPR resource information in SAS data set in 
IT Resource Management Admin library. */  

LIBNAME ADMIN <'location-of-ITRM-Admin-library'>;
PROC SORT DATA=WORK.LSPRDATA out=ADMIN.ITMS_SMF_LSPRDATA;
    BY CPCFMODL; 
RUN;

 
/*Allocate the backup copy of the SASHELP library      */
/*that uses PROC COPY to copy only the LSPR table      */
/*with the SELECT statement.                           */
/*Make sure you have exclusive udate access to the     */
/*SASHELP SAS library before you submit code.          */ 
     libname bkuphelp '<physical-location-of-backup-sashelp>';
     proc copy in=bkuphelp out=SASHELP;   
          select ITMS_SMF_LSPRDATA;     
     run;  

//jobname JOB          
//STEP1 EXEC SASPROC,OPTIONS=’SASHELP=SASHELP’         
//SASHELP DD DSN='&prefix.llWn.SASHELP',DISP=OLD
//SYSIN   DD *         
   libname bkuphelp '<physical-location-of-backup-sashelp> '; 
   proc copy in=bkuphelp out=SASHELP;    
        select ITMS_SMF_LSPRDATA;        
   run;      
/*Ouput contents of LSPR data information              */
   PROC PRINT=SASHELP.ITMS_SMF_LSPRDATA;   
   RUN; 

USERID.CONFIG(ENW0)
USERID.ENW0.SASHELP
USERID.D54002.ENW0.SASHELP