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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.