Hi, How should we arrange our SAS code to select and retain the highest salary for each year (2003, 2004, 2005) for every individual ( pnr ), while also capturing the corresponding company (CVR), start date, and education level for that highest salary? The goal is to output one row per person, with all relevant information attached to the highest salary for each year, ensuring no observations are lost or overwritten during the process. In the attached file, I have made an example how we would like the Output. Hope someone can help!
... View more