I'm trying to load a SAS table to Netezza and one of the issues I get is a communication link failure. Based on this discussion: https://communities.sas.com/t5/SAS-Data-Management/Communication-link-failure-when-upload-table-to-Netezza-database/td-p/486989   it may be because of one of my column values. However, I don't understand how to format that value when I load to Netezza. Here is how I load to netezza:   libname myPathToTable "\path\to\SAS\Table"; libname sdf odbc noprompt="server=xxxx; DRIVER={NetezzaSQL}; port=xxxx; database=xxxxx; username=xxx; password=xxxx;"; proc sql; create table sdf.table (DBCREATE_TABLE_OPTS 'distribute on (col1)' bulkload = YES) AS SELECT * FROM myPathToTable.mySASTable; quit; Now let's say I want to reformat col2 to no format. How would I do this?    Thanks in advance! ... View more

I have a table that I open in SAS and I noticed that when I scroll to about halfway through the table, the rest of the rows will have an error message on all of the columns stating:  Error:<?xml version="1.0" ?><Exceptions><Exception><SAS Message severity="Error> File myTable.DATA is damaged. </SASMessage></Exception></Exceptions>   This appears in every column and every row starting at about halfway through the table.   When I go to hover over any of the damanged rows, I get a popup that states: SAS Enterprise Guide has encountered a problem. We reccommend hat you save your work and restart SAS Enterprise Guide.    When I restart it, the same thing will happen. The data never gets fixed. It has around 7 million rows but I can open much bigger tables without a problem. Any help towards fixing this issue is greatly appreciated!   ... View more