I need the RunDate field to populate when the report was run, even if there are no results in order to show that it was run for each day. proc sql; create table work.test as select distinct query_for_test1 query_for_test1.field1 query_for_test1.field2 (datetime()) formate=datetime16.0 as RunDate from work.query_for_test1 as query_for_test1 Thank you!
... View more