proc sql;
create table term_unit_sql as
select business_section,subscription_year,subscription_number,vehicle_number,
case when substr(postal_code,1,1) in ("K","L","M","N","P") then "ON" else "XX" as Province,
ROUND((mdy(input(substr(expiry_date,5,2),2.),
input(substr(expiry_date,7,2),2.),
input(substr(expiry_date,1,4),4.))
-mdy(input(substr(effective_date,5,2),2.),
input(substr(effective_date,7,2),2.),
input(substr(effective_date,1,4),4.)))/365.25,.1) as TERM_UNIT
from 哪一个dataset;
quit;
|