If you previously had access to Netezza then it appears the installation used for you new computer is not the same as previously used. You might check with who did the install. Also the version of SAS you show, 9.4_M2 is more than a couple of years old. The latest version is 9.4_M8. ... View more

For below sample data which value would you want to keep for id=3? 5 or minus 5 or both? data have; infile datalines truncover; input id value; datalines; 1 1 1 2 2 3 2 -4 3 -5 3 1 3 5 4 6 ; proc sql; /* create table want as*/ select distinct * from have group by id having max(abs(value))=abs(value) ; quit;     ... View more