topic Re: count exactly no of days between two days in SAS Programming

count exactly no of days between two days

BrahmanandaRao — Wed, 08 Dec 2021 07:19:29 GMT

Hi Guys

suppose a person visit respective dates I want to count no of days between two dates

required answer is 2 days as per below dates

data count;
st_date ='01JAN2021'd;
end_date='02JAN2021'd;
fromat st_date end_date date9.;
count_total=intck('day',st_date,end_date);
put count_total= ;
run;

Re: count exactly no of days between two days

Kurt_Bremser — Wed, 08 Dec 2021 07:35:46 GMT

If you need to include both the start and end day, add 1 to the result.

INTCK counts the number of interval boundaries between the values.

Re: count exactly no of days between two days

BrahmanandaRao — Wed, 08 Dec 2021 07:40:18 GMT

suppose three days then

data count;
1st_date ='01JAN2021'd;
2nd__date='02JAN2021'd;
3rd_date='05APR2021'd;
fromat 1st_date 2nd_date 3rd_date date9.;
count_total=intck('day',st_date,end_date)+1;
put count_total= ;
run;

Re: count exactly no of days between two days

Kurt_Bremser — Wed, 08 Dec 2021 20:14:27 GMT

Apart from the obvious syntax error in the FORMAT statement, this code will only create missing values.

I STRONGLY suggest you run your code in your SAS environment and see what it does (Maxim 4).