Date Issue - Wierd!!!!!

[ja01]

Here is the SAS program I wrote to display a userid and the count of the userid:

proc sql;
create table address1 as
select addruserid, count(addruserid) as addrCount
from my.address
where addrdate between '26-feb-2007'd and '31-mar-2007'd
group by addruserid;
run;
Everything works okay except the date.

I get a message that says,NOTE 49-169: The meaning of an identifier after a quoted string may change in a future SAS
release. Inserting white space between a quoted string and the succeeding identifier is recommended.

I had been running similar programs for months without issue. I am running SAS 9.3. Was there a change that makes this display of dates incorrect?? Is there a fix for this??

 

[klaz2002]

It looks good to me. I am running 9.1 so I havn't seen your problem. Perhaps take the dashes out of your 'date' value.
Also you must realize that the message is a NOTE and not even a warning so I would ignore it.
Klaz

 

[ChrisW75]

Take the hyphens out of the dates, should be

 '26FEB2007'd and '31MAR2007'd

Enjoy.


Chris
Business Analyst, Code Monkey, Data Wrangler.
SAS Guru.