My apologies Reeza. Here is the sample data as text. data WORK.IOVATIONNOW2; infile datalines dsd truncover; input Date:YYMMD7. Count:COMMA20. mid:$20. product:$30. vendor:$30. Price:4.2 total_price:32.; format Date YYMMD7. Count COMMA20. Price 4.2; datalines; 2018-08 471,190 All Environments RM360 Iovation 0.06 25915.45 2018-06 385,706 All Environments RM360 Iovation 0.06 21213.83 2018-02 348,405 All Environments RM360 Iovation 0.06 19162.275 2018-10 144 All Environments RM360 Iovation 0.06 7.92 2018-05 362,751 All Environments RM360 Iovation 0.06 19951.305 ;;;; here is what I need the data to return: 2018-08 150,000 All Environments RM360 Iovation 0.06 9000 2018-08 321,190 All Environments RM360 Iovation 0.0525 16862.475 2018-06 150,000 All Environments RM360 Iovation 0.06 9000 2018-06 235,706 All Environments RM360 Iovation 0.0525 12374.565 2018-07 150,000 All Environments RM360 Iovation 0.06 9000 2018-07 198,405 All Environments RM360 Iovation 0.0525 10415.26 2018-05 150,000 All Environments RM360 Iovation 0.06 9000 2018-05 250,000 All Environments RM360 Iovation 0.06 13125.00
... View more