Hello, I have read into SAS a Netezza table where one of the columns is a date ( The column type was date ) . Now I am trying to create several sub-tables in SAS, but I'm having trouble comparing dates in SAS. Code to create first SAS dataset proc sql; connect to netezza (server=xxxx database=xxxx PORT = xxxx user=xxxx password="&mysaspasswd" connection=global); create table SASDATA.WEEKLY_REPORT_RT_LOAD as select * from connection to netezza (select a.* from WEEKLY_REPORT_RT_LOAD a order by 1,2); run; code for subtable %let starttime = today() - 30; proc sql; create table sasdata.rtload_tab_1 as select * from SASDATA.WEEKLY_REPORT_RT_LOAD where marketdate >= &starttime; run; below is the picture of the column (variable) marketdate that i am trying to filter on. While the table is created. The data has not been filtered by the date as i would have thought. As a matter of fact it is not being filtered at all. Any help would be appreciated. Thanks, Tom
... View more