Hi All , I have an input file : For PRODUCT1 61 Total Exceptions Were Found For PRODUCT1 8 Exceptions Were ignored For PRODUCT1 32 Total Baseline Violations Were Found -------------------------------------------------------- PRODCHK For : PRODUCT1 DATE: 17 Sep 2018 TIME: 00:10:08 ======================================================== Object : SAMPLE1 Type : FLAT Attribute : 56 Should_Be : TESTED Actual : TESTED Baseline : NO =========================================== =========================================== Object : SAMPLE2 Type : FLAT Attribute : 22 Should_Be : TESTED Actual : NONTESTED Baseline : YES =========================================== =========================================== Object : SAMPLE3 Type : OVAL Attribute : 32 Should_Be : TESTED Actual : TESTED Baseline : NO =========================================== =========================================== I used to _infile_ to read the records and produce an output like Product Object Type Attribute Should_Be Actual Baseline Product1 SAMPLE1 FLAT 56 TESTED TESTED NO SAMPLE2 FLAT 22 NONTESTED TESTED NO SAMPLE3 OVAL 32 TESTED TESTED YES In the output product1 is coming in the first row . My requirement is product 1 should come before all 3 observations . Like Product Object Type Attribute Should_Be Actual Baseline Product1 SAMPLE1 FLAT 56 TESTED TESTED NO Product1 SAMPLE2 FLAT 22 NONTESTED TESTED NO Product1 SAMPLE3 OVAL 32 TESTED TESTED YES Shall I write two separate DATA statement and then two to perform a one to many merge . Infact I tried that but merge is quite complex . I could able to assign product1 to a variable called ProductValue, but not sure how to append it at the beginning of each observation . Thanks .
... View more