How can I flag all members of a household if one (but not all) members of that household has a certain characteristic?
For example, I want to give every unique entry a flag to identify whether the household has at least one member over the age of 40 in this set:
Household, Age
1 10
1 15
1 45
2 30
2 30
3 55
4 25
4 18
So everyone in household 1 and 3 would have a fortyplus = 1, while all others would have fortyplus=2.
Edit: alternativey, how could I just give everyone in the household a MAXHHLDAGE = [age of oldest member].
Nevermind, found the solution here: https://communities.sas.com/t5/Base-SAS-Programming/Find-the-maximum-number-within-a-subset-of-a-col...
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.