topic Re: comparing date in SAS Enterprise Guide

comparing date

alepage — Tue, 10 Nov 2020 21:29:41 GMT

Hello,

I have two datasets. In the first one, the var date1 as the date format 23dec2020 while in the other dataset, the date2 as the following date format : 2020-12-23 (yyyy-mm-dd).

How can I bring back both to numerical value ex; 22272 in order to compare both dataset.

Regards,

Re: comparing date

PaigeMiller — Tue, 10 Nov 2020 21:31:43 GMT

According to PROC CONTENTS, is date1 character or numeric? According to PROC CONTENTS, is date2 character or numeric?

Re: comparing date

alepage — Tue, 10 Nov 2020 21:41:33 GMT

it seems that they are both numeric but not using the same format

Re: comparing date

PaigeMiller — Tue, 10 Nov 2020 21:46:27 GMT

For numeric variables, format doesn't matter when you compare variables.

if date1<date2 then ... ;

works regardless of format. Formats just change the appearance, they don't affect the actual date values.

Re: comparing date

alepage — Tue, 10 Nov 2020 21:49:11 GMT

data test;
date = '23dec2020'd;
date2=2020-12-23;/*yyyy-mm-dd*/
if date1 eq date2 then
do;
flag=1;
end;
else
do;
flag=0;
end;
run;

Re: comparing date

alepage — Tue, 10 Nov 2020 21:50:35 GMT

data test;
date1 = '23dec2020'd;
date2=2020-12-23;/*yyyy-mm-dd*/
if date1 eq date2 then
do;
flag=1;
end;
else
do;
flag=0;
end;
run;

The flag value should gives one...

Re: comparing date

PaigeMiller — Tue, 10 Nov 2020 22:02:59 GMT

Date2 is not a SAS date value, nor is it formatted as YYYY-MM-DD.

Date2 is 2020 minus 12 minus 23, which is ... well you do the math.

If you want Date 2 to be a SAS date value, you should use this:

date2=input('2020-12-23',yymmdd10.);