Our team has run into an issue with loading data from SAS to Netezza through SAS EG for some time. When the load completes, SAS hangs until SAS finishes pulling the data back into the Output Data tab. This can be fixed by selecting the 'Maximum number of datasets to add to the project' to 0. SAS frezzes typically from 6-10 minutes regardless of the file size. This is inconvenient as it is useful to have the table displayed in the output data tab in all other circumstances.
It would be very helpful if there was an option through coding that would allow us to set the max number of output data sets to zero for individual code nodes instead of the entire project.
An example of code where SAS freezes until the results are pulled back into the output data tab.
proc sql;
create table nzanlyp.testing (bulkload=YES bl_options='logdir "s:\temp\netlogs"') as
select *
from test;
quit;