proc sql; create table cf_HYFI&minyear.&minmonth._&maxyear.&maxmonth._N_Harmony as select a.years as year, a.cie, a.province_cd, a.distribution, a.group as LineOfBusiness, a.SAS_WP_corr format=NLNUM15.0, a.SAS_WU_corr format=NLNUM15.0, b.writtenPremium format=NLNUM15.0, b.writtenUnit format=NLNUM15.0, (a.SAS_WP_corr - b.writtenPremium)*100/a.SAS_WP_corr as wp_diff format= 8.2, (a.SAS_WU_corr - b.writtenUnit)*100/a.SAS_WU_corr as wu_diff format= 8.2 from SAS_Summary as a inner join harmony_trx...
