topic Re: Date difference in SAS Procedures

Date difference

SAS83 — Tue, 24 May 2011 15:02:10 GMT

I am having two dates in the SAS dataset.
x y
200801 200903
200102 200111

I need to find the number of months these dates apart.

I have used intck but answer looks different.

Can some one help?

Re: Date difference

SAS83 — Tue, 24 May 2011 15:25:36 GMT

I got it ..

Below are my original dates :

EFdt PEDt
20100101 201006
20000612 200009

I used this equation to get the difference..

AGE = intck('month',MDY(mod(int(EFDT/100),100),mod(EFDT,100),int(EFDT/10000)),
MDY(mod(PEDT,100),1,int(PEDT/100)));

Re: Date difference

art297 — Tue, 24 May 2011 15:37:21 GMT

Your code would be a lot simpler if you input the dates as dates rather than numbers. E.g.:
[pre]
data want;
informat EFdt yymmdd8.;
informat PEDt yymmn6.;
input EFdt PEDt;
age=intck('month',EFdt,PEDt);
cards;
20100101 201006
20000612 200009
;
[/pre]
Art
-------
> I got it ..
>
> Below are my original dates :
>
> EFdt PEDt
> 20100101 201006
> 20000612 200009
>
>
> I used this equation to get the difference..
>
>
> AGE =
> intck('month',MDY(mod(int(EFDT/100),100),mod(EFDT,100)
> ,int(EFDT/10000)),
> MDY(mod(PEDT,100),1,int(PEDT/100)));

Re: Date difference

SAS83 — Tue, 24 May 2011 18:37:21 GMT

Thanks Art..