topic Reg Date Macro in SAS Programming

Reg Date Macro

sas_Forum — Tue, 10 Apr 2012 07:27:51 GMT

Actually i am having two tables and check the counts of two datasets based on dates i am doing in this way but i ma getting

ERROR: Expression using equals (=) has components that are of different data types.
How can i check the counts

data l;
input id date date9.;
format date date9.;
cards;
2 13jan2012
2 13jan2012
2 13jan2012
run;

data l2;
input id date date9.;
format date date9.;
cards;
2 12jan2012
2 12jan2012
2 12jan2012
2 13jan2012
2 13jan2012
2 13jan2012
;
run;

proc sql;
select max(date) format=date9. into:maxdt from l2;
quit;

proc sql;
select count(*) into:S1 from l;
select count(*) into:s2 from l2 where date="&maxdt.";
quit;

ERROR: Expression using equals (=) has components that are of different data types.

Ksharp — Tue, 10 Apr 2012 07:48:03 GMT

You need this:

select count(*) into:s2 from l2 where date="&maxdt."d ;

Ksharp

sas_Forum — Tue, 10 Apr 2012 07:55:36 GMT

Thqs Ksharp

manojinpec — Tue, 10 Apr 2012 08:15:21 GMT

i guess .(dot) after maxdt is not required.Not sure incase i am wrong

Ksharp — Tue, 10 Apr 2012 08:19:58 GMT

You are right. It doesn't matter whether the dot is there.

the same result will be .

Haikuo — Tue, 10 Apr 2012 11:41:59 GMT

Another approach, not as slick of course, is to remove 'format=' and convert the date variable into numeric digits.

proc sql;

select max(date) into:maxdt from l2;

quit;

proc sql;

select count(*) into:S1 from l;

select count(*) into:s2 from l2 where date=input("&maxdt.",20.);

quit;

Or keep the format and then use informat to convert:

proc sql;

select count(*) into:S1 from l;

select count(*) into:s2 from l2 where date=input("&maxdt.",date9.);

quit;

Haikuo