Hi Community, Can anyone please help me with this logic? For each subject, whenever cycle name changes I want Cycle = OldCycle+1. Source Dataset: Subject Cycle 1 Cycle 1 1 Cycle 1 1 Cycle 2 1 Com Cycle 1 1 Com Cycle 2 1 Com Cycle 3 1 Brid Cycle 1 1 Brid Cycle 1 1 Brid Cycle 1 2 Ind Cycle 1 2 Ind Cycle 1 2 Ind Cycle 2 2 Com Cycle 1 2 Com Cycle 1 2 Com Cycle 3 2 Brid Cycle 1 2 Brid Cycle 1 2 Brid Cycle 3 Output Data set: Subject Cycle Cycle_no 1 Cycle 1 Cycle 1 1 Cycle 1 Cycle 1 1 Cycle 2 Cycle 2 1 Com Cycle 1 Cycle 3 1 Com Cycle 2 Cycle 4 1 Com Cycle 3 Cycle 5 1 Brid Cycle 1 Cycle 6 1 Brid Cycle 1 Cycle 6 1 Brid Cycle 1 Cycle 6 2 Ind Cycle 1 Cycle 1 2 Ind Cycle 1 Cycle 1 2 Ind Cycle 2 Cycle 2 2 Com Cycle 1 Cycle 3 2 Com Cycle 1 Cycle 3 2 Com Cycle 3 Cycle 4 2 Brid Cycle 1 Cycle 5 2 Brid Cycle 1 Cycle 5 2 Brid Cycle 3 Cycle 6 ... View more

I want to add SEQNUM variable in below dataset and I want numbering to get re-started from 1 as soon as EMPID changes....means for first 8 record SEQNUM should have normal....1, 2, 3...8 but for 9th record EMPID changed then it should have again 1, 2, etc. Like this for entire table. Any easy way to do this. I want to use proc sql only. Current Dataset   ... View more

Data Set -  How to convert this character dataset to variable. So that I can fetch data out of it....Having issue due to missing value... Tried - RFICDAT = input(RFICDAT, 10.), RFICDAT = input(RFICDAT, 10.) ... View more