Code: Program1.sas data Time; input Period : $20. StartDate : date9. EndDate : date9.; format StartDate EndDate date9.; cards; Period01 01Jan15 28Jan15 Period02 29Jan15 26Feb15 Period03 27Feb15 25Mar15 ; run; data Car; input car $ RentalDate : date9. ReturnedDate : date9. ; format RentalDate ReturnedDate date9.; cards; CarA 15Jan15 1Mar15 CarB 20Feb15 15Mar15 ; run; data key; set time; do date=StartDate to EndDate ; output; end; format date date9.; keep Period date; run; data temp; set car; do date=RentalDate to ReturnedDate ; output; end; format date date9.; keep car date; run; proc sql; create table want as select car,Period,count(*) as n from key as a,temp as b where a.date=b.date group by car,Period ; quit;
... View more