BookmarkSubscribeRSS Feed
JoseC
Calcite | Level 5

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.

1 REPLY 1
art297
Opal | Level 21

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.

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 981 views
  • 0 likes
  • 2 in conversation