I'm trying to create a new variable called "batch" and then assign the value to it when TR_RT contains "B A T C H" then batch=Account. The following rows after "B A T C H" will also have the same value as "B A T C H" until the next "B A T C H" is found. Then batch=Account of the new "B A T C H". I use Base SAS 9.4. Any help would be greatly appreciated. Thanks, Jeff   Have: Obs SeqNum TR_RT Account 1 5900583193 B A T C H 7020 2 5900583194 5010 0005 9860608265 3 5900583195 0531 0030 9860608265 4 5900583196 0110 0002   5 5900583197 0631 0027   6 5900583198 0531 0030   7 5900583199 0531 0030   8 5900583200 0531 0030   9 5900583201 B A T C H 1234 10 5900583202 0531 0030   11 5900583203 0531 0030   12 5900583204 0531 0030   13 5900583205 0531 0030   14 5900583206 0631 0027 9860608265 15 5900583207 B A T C H 4587 16 5900583208 0531 0030   17 5900583209 0631 0027   18 5900583210 0531 0030   19 5900583211 0531 0030   20 5900583212 0531 0030   21 5900583213 0531 0030   22 5900583214 0531 0030     Want: Obs SeqNum TR_RT Account Batch 1 5900583193 B A T C H 7020 7020 2 5900583194 5010 0005 9860608265 7020 3 5900583195 0531 0030 9860608265 7020 4 5900583196 0110 0002   7020 5 5900583197 0631 0027   7020 6 5900583198 0531 0030   7020 7 5900583199 0531 0030   7020 8 5900583200 0531 0030   7020 9 5900583201 B A T C H 1234 1234 10 5900583202 0531 0030   1234 11 5900583203 0531 0030   1234 12 5900583204 0531 0030   1234 13 5900583205 0531 0030   1234 14 5900583206 0631 0027 9860608265 1234 15 5900583207 B A T C H 4587 4587 16 5900583208 0531 0030   4587 17 5900583209 0631 0027   4587 18 5900583210 0531 0030   4587 19 5900583211 0531 0030   4587 20 5900583212 0531 0030   4587 21 5900583213 0531 0030   4587 22 5900583214 0531 0030   4587 ... View more

Hi everyone, Here's a sample dataset. Obs SeqNum Amount NegSign CES_APPL 10400 1700553755 1035 72   FCD 10401 1700553756 53760 90   DDA 10402 1700553757 27746 05   DDA 10403 1700553758 65240 21   AGL 10404 1700553759 5910 97 - ABC 10405 1700553760 91130 71   FCD 10406 1700553761 10888 23   DDA 10407 1700553762 2622 13   DDA 10408 1700553763 124066 24   DDA 10409 1700553764 7067 77   DDA 10410 1700553765 40 21   DDA 10411 1700553766 5831 73   DDA 10412 1700553767 1030 98 - AGL 10413 1700553768 43648 52   DDA 10414 1700553769 18695 12   FCD 10415 1700553770 9439 83   XYZ 10416 1700553771 12219 36   DDA 10417 1700553772 7256 50   DDA 10418 1700553773 40698 54   DDA 10419 1700553774 16211 15 - DDA 10420 1700553775 600 00   DDA 10421 1700553776 53760 90   DDA I'd like to output some rows which meet the following logic (in this case, obs#10404 through obs#10411) : (1) The first row to output: If NegSign = (-) and CES_APPL = ABC or AGL   (2) And then ALL following rows: CES_APPL = DDA or FCD. If it contains something else other than these 2 codes, don't output the whole chunk.    For example: -Obs#10400 through obs#10403 will NOT be outpout since there is no starting row with NegSign = (-). -Obs#10404 through obs#10411 will be OUTPUT since obs#10404 NegSign=(-) and CES_APPL = ABC, and then ALL the following rows CES_APPL = DDA or FCD. -However, obs#10412 through obs#10418 will NOT be output even though obs#10412 NegSign = (-) and CES_APPL = AGL, but one of the following rows (obs#10415) CES_APPL = XYZ. Not ALL CES_APPL = DDA or FCD. It has to be ALL or NOTHING within the block. -Obs#10419 through obs#10421 will NOT be output since obs#10419 NegSign = (-), but CES_APPL ≠ ABC or AGL.   So, my idea is to mark the starting row which meet the criteria (NegSign = (-) and CES_APPL = ABC or AGL. Then, check criteria (2) for the next row only if (1) is met. Then output, otherwise, don't output. Stop when the next row NegSign = (-), then go back to check (1) again.   I use Base SAS 9.4.   I'm not sure this logic could be done in SAS or not. Any help would be greatly appreciated. Thanks, Jeff     ... View more