Hey! I have a dataset that looks somewhat like this: EMPLID CURRENT_COLLEGE 1 ABC 1 ABC 1 XYZ 1 XYZ 2 CED 2 VIN 2 VIN I have to compare the values for each row in current_college and create a separate column called 'Change' that captures if the college for each ID has changed compared to the first observation. The output table should look something like this: EMPLID CURRENT_COLLEGE CHANGE 1 ABC 0 1 ABC 0 1 XYZ 1 1 XYZ 1 2 CED 0 2 VIN 1 2 VIN 1 I have been scratching my head over this for hours and I have just started working with SAS! Are there any efficient ways of grouping observations in SAS (like 'group' in dplyr package in R)? Thanks 🙂
... View more