Hello, i need to create this table using the sql procedure, i try to work with the sql procedure, because i couldn't calculate the ratio sum(exp_prem)/sum(exposure) using the proc tabulate, proc sql ; create table ss2 as select code,year sum(exposure) as exposition, sum(exp_prem)/sum(exposure)as premium, group by code, year; quit; so i get this table as result, What should i do, Thank you   ... View more

Hello, i need to join two sas tables with condition, The first tables contains a list of contract with two dates : start date and expiration date, and also the premium. the second table contains claims with occurence date, amounts and contract. i have to join those tables by contract, the occurence date have to be between start date and expiration date. A contract may have many claims, i need to sum the amounts of claims and affected to the contract . My main problem is how to join those tables and to avoid duplicates (premium)   i Tried to use the SQL procedure, right join/full join. but it doesn't work, also  i tried the merge procedure,      Thanks a Lot           ... View more