Comparing Dates from Netezza vs SAS

twelch — Wed, 06 Jun 2012 12:46:46 GMT

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

Re: Comparing Dates from Netezza vs SAS

ballardw — Wed, 06 Jun 2012 16:42:18 GMT

From the displayed values of MARKETDATE it is a DATETIME variable and the STARTTIME you created is a DATE variable.

I would try modifying the sql to

where datepart(marketdate) ge &starttime;

Re: Comparing Dates from Netezza vs SAS

twelch — Wed, 06 Jun 2012 16:59:53 GMT

Thanks. That worked like a charm.

topic Comparing Dates from Netezza vs SAS in SAS Enterprise Guide

Comparing Dates from Netezza vs SAS

Re: Comparing Dates from Netezza vs SAS

Re: Comparing Dates from Netezza vs SAS