Tried the Hash method as below it's bringing only one record as below you see there should have been two match for STMYF10C However only with volser K63045 came out instead of both M02163 so not sure why it dropped M02163 match for the Jobname .... M02163 ,30APR2013 ,30DEC2000 ,18:35 ,NNNNDDNN ,Y ,N ,N ,600F ,600F ,C ,SGVTS00 ,MCVTSC19 ,SMSTAPE1 ,TAPMED02 ,17844313 ,ONLY_REMOTE ,STMYF10C ,CHECKCC ,dataset,9999999 K63045 ,30MAY2013 ,01JAN2005 ,12:22 ,NNNNDDNN ,Y ,N ,N ,600F ,600F ,C ,SGVTS00 ,MCVTSC19 ,SMSTAPE1 ,TAPMED02 ,86323916 ,ONLY_REMOTE ,STMYF10C ,CHECKCC ,dataset,9999999 DATA VTSREP_HASH; IF _N_ = 1 THEN DO; IF 0 THEN SET MERGE_FINAL(KEEP=VOLSER DATE_CACHE TIME_IN_CACHE CCM DATA_INCONSISTENT PROPERTIES_INCONSISTENT VOLUME_DAMAGED PENDING_CATEGORY CURRENT_CATEGORY CONSISTENT_TYPE STORAGE_GROUP MANAGEMENT_CLASS STORAGE_CLASS DATA_CLASS SIZE FLAG DSN DATE) ; DECLARE HASH HH(DATASET:"MERGE_FINAL"); RC=HH.DEFINEKEY("CJOB"); RC=HH.DEFINEDATA("VOLSER","DATE_CACHE","TIME_IN_CACHE","CCM", "DATA_INCONSISTENT","PROPERTIES_INCONSISTENT", "VOLUME_DAMAGED","PENDING_CATEGORY","CURRENT_CATEGORY", "CONSISTENT_TYPE","STORAGE_GROUP","MANAGEMENT_CLASS", "STORAGE_CLASS","DATA_CLASS","SIZE","FLAG", "DSN","DATE"); RC=HH.DEFINEDONE(); END; DO UNTIL(EOF); SET VTSREP END=EOF; RC=HH.FIND(KEY:CJOB); IF RC=0 THEN DO; OUTPUT VTSREP_HASH; END; END; PROC PRINT DATA=VTSREP_HASH;
... View more
