it partially works actually, i did achieve that anyway. I have few values like %%%bat , %%%BBAT,%%%PRD etc.., this code label these all the values "FOUND" and when i pass the format into next dataset. i achieve the result for those values which exist in the dataset but not which are not matching with Qname dataset( such as %%%bat , %%%BBAT,%%%PRD )
I want these values %%%bat , %%%BBAT,%%%PRD as missing in the output.
------------------------------------------------------------
DATA QNAME; INFILE QLNAME; INPUT NAME $8.; PROC SORT NODUPS NODUPKEYS DATA=QNAME; BY NAME; DATA DS; SET QNAME END=LAST; RETAIN FMTNAME '$HTNFMT'; START=NAME; LABEL='FOUND'; OUTPUT; IF LAST THEN DO; HLO='O'; LABEL='NOT FOUND'; OUTPUT; END; RUN; PROC FORMAT CNTLIN=DS; PROC PRINT DATA=DS; DATA NEW; SET DETAIL.BATJOB01(KEEP=SYSID RACFUSID); TYPE=PUT(RACFUSID,$HTNFMT.); PROC SORT NODUPS NODUPKEYS DATA=NEW; BY SYSID RACFUSID; PROC PRINT DATA=NEW; WHERE TYPE='FOUND'; . . . . . . . . . . . . . . . .
... View more