Hi there, I have data from 2005 to 2016. The counting unit of the data is event_id, each row is one event id and has demographic data associated with that event. One of the variables in the dataset is a unique person identifier we shall call it personid, a person may have many different events. My boss would like me to count unique people by sex. However, as the data is of interesting quality you might have say 7 different events for one personid and they might say FEMALE 5 times then MALE once and unknown once. I would like to, over the entire collection (forgetting about year), attach the most commonly occurring sex to the unique person identifier, then I guess join the associated event ids to the person identifier for each year. I will make another data set for unique people at this point that I can pull from. Since there are like over 400,000 records/events, how do I go about finding the most occurring value for sex and attach it to the person identifier? (the more efficient the better). Using SAS 9.4 Thank you. An example of what my data looks like below: event id PERSONID sex other demographic year 86590 767898 FEMALE xxx 2005 86591 767898 FEMALE xxx 2005 86592 767898 MALE xxx 2007 86593 767898 UNKNOWN xxx 2008 Thanks in advance for your help!
... View more