This is the code that I wrote:
data libname.abc;
set libname.abc;
if num_var > 72 and date_var < '08FEB2022'd then num_var = 72;
run;
This was supposed to cap the value of num_var at 72 if it was before that specific date. However, when I open the table libname.abc on SAS EG and put numvar>72 after clicking on the where button, I see several records where the date_var has a value from years before 2022. Please note that date_var is a datetime variable.
However, when I query it as follows it doesn't return any rows:
proc sql;
create table temp_abc as
select * from libname.abc where num_var > 72 and date_var < '08FEB2022'd;
quit;
This eventually makes me think there's something wrong with the data step condition but I can't figure out what it is.
... View more