Hi I am new toSAS. I have the following scenario and would require help to resolve. Input file: EMPID EFFDT EFFSEQ ACTION Emp1 2016-01-01 5 H Emp1 2016-01-01 7 M Emp1 2016-01-01 8 R Emp1 2016-02-02 0 12 Emp1 2016-05-04 3 12 Emp1 2016-05-04 4 13 If an Employee has a EFFSEQ starting with 5 in the input file for a particular EFFDT, then his EFFSEQ should increment like 5,6,7... If an Employee has a EFFSEQ starting other than 5 in the input file for a particular EFFDT, then his EFFSEQ should increment like 0,1,2.. Here in this case, I would expect the below output. EMPID EFFDT EFFSEQ ACTION Emp1 2016-01-01 5 H Emp1 2016-01-01 6 M Emp1 2016-01-01 7 R Emp1 2016-02-02 0 12 Emp1 2016-05-04 0 12 Emp1 2016-05-04 1 13 Thanks in advance.
... View more