topic Re: Date Not Matching in SAS Programming

Date Not Matching

SARATH_IDBI — Wed, 24 Mar 2021 08:44:24 GMT

Issue with the below code.
The Report date is not getting matched in the below code. So, no rows are getting updated.

%let REPORT_DATE=%sysfunc(putn(%sysevalf(%sysfunc(today()) - 1), yymmddd10.)); */to get yesterday date in YYYY-MM-DD format/*

proc sql;
connect to teradata (user="***********" password="*************" server="****************"
mode=teradata);

create table FLOW_YESTERDAY as
select * from connection to teradata
( SELECT * FROM EDWDB.FLOW_ITD
WHERE CAST(T1_DATE AS DATE) = &REPORT_DATE ); */T1_DATE='2021-03-23' gives the required output/*
disconnect from teradata;
quit;

proc append base=SASVA.FLOW data=FLOW_YESTERDAY;
run;

Please provide a way around.

Re: Date Not Matching

SASKiwi — Wed, 24 Mar 2021 09:03:24 GMT

Looks like you need to wrap the macro variable in single quotes but still resolve the value. Here is one way:

%let REPORT_DATE=%sysfunc(putn(%sysevalf(%sysfunc(today()) - 1), yymmddd10.)); */to get yesterday date in YYYY-MM-DD format/*

 

proc sql;
connect to teradata (user="***********" password="*************" server="****************"
mode=teradata);

create table FLOW_YESTERDAY as
select * from connection to teradata
( SELECT * FROM EDWDB.FLOW_ITD
WHERE CAST(T1_DATE AS DATE) = %str(%')&REPORT_DATE%str(%') );  */T1_DATE='2021-03-23' gives the required output/*
disconnect from teradata;
quit;

Re: Date Not Matching

Kurt_Bremser — Wed, 24 Mar 2021 11:19:42 GMT

Instead of

%let REPORT_DATE=%sysfunc(putn(%sysevalf(%sysfunc(today()) - 1), yymmddd10.));

data _null_;
call symputx("report_date","'"!!put(today()-1,yymmddd10.)!!"'","g");
run;

to add single quotes.

Re: Date Not Matching

Tom — Wed, 24 Mar 2021 13:01:27 GMT

You are comparing your date variable to the formula 2021 minus 3 minus 23 .

Add quotes.

Here is a simple macro to make it easier.

%squote()