thank you all experts for all your help. Mr. ErikLund_Jensen, this syntax below is not working. substr(put(variable,8.),1,4) ERROR: Expression using different data types. May I ask if how do I get the output for a day from sysdate in SAS. In Oracle, I used SELECT DISTINCT a.APPLICATION_ID, a.CRTD_USER_ID, a.FRM_TYP_ID FROM APPLICATION_CDIM a WHERE (trunc(a.CRTD_LOAD_DTTM) = trunc(sysdate - 1) OR trunc(a.UPTD_LOAD_DTTM) = trunc(sysdate - 1)); if I want to run the query in SAS, I don't find trunc(sysdate -1) select DISTINCT a.APPLICATION_ID, a.CRTD_USER_ID, a.FRM_TYP_ID FROM APPLICATION_CDIM a where weekday(a.updt_load_dttm) = 1; and get 0 row and not sure it's corrected to pull a day old from a column, updt_load_dttm (this column declared as timestamp in oracle and datetime27.6 in sas) and according from sas, I see the a tons of million rows upload today thank you sir and all. v/r, Bach-Nga
... View more