Help using Base SAS procedures

mdy function inside proc sql

Reply
Occasional Contributor
Posts: 6

mdy function inside proc sql

Why does

my_date = mdy ('08', '06', '2010');

work perfectly well inside data steps, but inside proc sql, it generates an error message:

ERROR: Function MDY requires a numeric expression as argument 1.
ERROR: Function MDY requires a numeric expression as argument 2.
ERROR: Function MDY requires a numeric expression as argument 3.
Respected Advisor
Posts: 4,173

Re: mdy function inside proc sql

Posted in reply to kranikai_2
MDY requires numeric values as input. Your statement should therefore look like:
my_date = mdy (08, 06, 2010);

The data step seems to be more tolerant but even there you get the following note with you code:

NOTE: Character values have been converted to numeric values

HTH
Patrick
Occasional Contributor
Posts: 6

Re: mdy function inside proc sql

> The data step seems to be more tolerant

That's just what I'm wondering. For me, it seems somewhat illogical that rules concerning data types may vary depending on context.

Well, this causes no real practical problems for me, I'm just curious and would like to know why the language has been designed in that way. Plus, I have to remember what is allowed where.
Super Contributor
Super Contributor
Posts: 3,174

Re: mdy function inside proc sql

Posted in reply to kranikai_2
Suggest you contact SAS tech support with your concern - unless you are merely broadcasting into this digital fjord, not necessarily looking for a response from an audience, comprised mostly of SAS users, not SAS software developers.

Scott Barry
SBBWorks, Inc.
Ask a Question
Discussion stats
  • 3 replies
  • 1386 views
  • 0 likes
  • 3 in conversation