You have to know the DATE format waited by SQLserver.
Does the Accountid passes as you do without the doubles quotes ?
Selon Raj <ramesh.chakri@GMAIL.COM>:
> how do u pass dates to a stored procedure?
> say with the following macro variables, I believe the dataofbirth
> stored just as text. If the stored procedure expects a date how to pass
> %let dateofbirth = 01Jan1968;
> %let AccountID = 333;
> create table debug1.sas_personInfo as select *
> from connection to oledb
> ( dbo.GetpersonInfo &dateofbirth &accountid );
> The above code doesnt work.!!