I have simple one-to-many merge code like this... data baseball.playershighestsalary; merge baseball.players (in=InMaster) baseball.salaries (in=InSalaries); by playerID; if InMaster and InSalaries; keep playerID birthYear birthMonth birthCountry salary; run; Salaries dataset contains a row for each player for each year, so there are multiple rows for most players. I simply want my merged dataset to include one row per player, including the max salary that player ever received (from the Salaries dataset). How to do it? I'm a newbie working on a final project in a SAS programming class, so I appreciate any solution or quick tip. First time trying to get help on this community! Thanks, Steve
... View more