I have rows with a unique id and number of years they were active. There are in some cases two rows with the same id and I would like to combine the rows so there is only one indicator and the years combine into a sum.
You probably want to use proc summary with ID as a by variable, but you would have to provide some info about your data to get more specific guidance. It always helps to provide a sample data file (in datastep form), along with your desired result, to get the best feedback.
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Registration is open
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss. Register now and lock in 2025 pricing—just $495!