libname nzwork netezza server=server-name database=database-name user=user-ID password=password preserve_names=yes; proc sql; create view work.query_for_class_nz as select t1.name, t1.sex, t1.age from nzwork.class_nz t1 where t1.age > 14 order by t1.name; quit; /* contains the order by clause */ proc sql; create view work.query_for_class_nz_0003 as select t1.sex, /*sum_of_age */ (sum(t1.age)) as sum_of_age from work.query_for_class_nz t1 group by t1.sex order by t1.sex; quit; /* contains the where clause */ proc sq; create table work.query_for_class_nz_0001 as select t1.sex, t1.sum_of_age from work.query_for_class_nz_0003 t1 where t1.sex = 'Z'; quit;

NETEZZA_8: Prepared: on connection 3
 select t1."Sex", SUM(t1."Age") as "SUM_of_Age" from "TEST".."CLASS_NZ" t1 where
t1."Age" > 14 group by t1."Sex" order by
t1."Sex" asc

proc sql; create view work.query_for_class_nz_0003 as select distinct t1.sex, /*sum_of_age */ (sum(t1.age)) as sum_of_age from work.query_for_class_nz t1 group by t1.sex; quit; proc sq; create table work.query_for_class_nz_0001 as select t1.sex, t1.sum_of_age from work.query_for_class_nz_0003 t1 where t1.sex = 'Z'; quit;

NETEZZA_8: Prepared: on connection 3
 select distinct t1."Sex", SUM(t1."Age") as "SUM_of_Age" from "TEST".."CLASS_NZ"
t1 where t1."Age" > 14 group by t1."Sex"