Use sinqle quotation marks around the date value on the %LET MACRO_VAR statement under the following conditions:
- You use a macro variable for a date value in a WHERE clause.
- You use the SQL Passthrough facility of SAS/ACCESSÂ Interface to ODBC.
%let startsql = '05/07/2000';
proc sql ;
connect to ODBC as &iwsconn
(datasrc=&iwsdb
user=&iwsid
password=&iwspw);
**---------------------------------------------------------------;
* Inspection information. ;
**---------------------------------------------------------------;
create table insp_upd as
select * from connection to &iwsconn
(SELECT
"Program" = I.ProgramId,
"Client" = I.ClientId,
I.InspectionId,
"Inspectr" = I.InspectorId,
I.ReferenceNo,
I.SysAddDt,
I.SysAddId
FROM Inspection I (NOLOCK)
WHERE (I.StatusUpdDate >= &startsql)
) ;
disconnect from &iwsconn;
quit;