LibName trx SPDE "/.../transaction/" ; %Let varToKeep = system lineOfBusiness distribution company companyDivision region province accountingYear accountingYearMonth writtenPremium writtenUnit driverType ; Data harmony_trx ; Set trx.prm_trx_: (Keep=&varToKeep. ); Where accountingYear ge 2024 And accountingYearMonth LE 202509; If distribution = 'Prestige' Then distribution = 'Broker'; If driverType = 'Occasional' Then writtenUnit = 0; Run; proc freq data=harmony_trx; table driverType; run; the...
