I’m trying to upload a SAS table to Redshift using the following simple command:
data rf.rsv_standing_cohort;
set epi.rsv_standing_cohort;
run;
where the “epi” library is on my local server and the “rf” library refers to my Redshift schema.
However, I’m getting the following error – part of my table is not being uploaded (original table size is 35,392 records).
Any ideas why the table upload is incomplete?
NOTE: SAS variable labels, formats, and lengths are not written to DBMS tables.
ERROR: CLI execute error: [SAS][ODBC Redshift Wire Protocol driver]This is either an Unknown Type or is not supported currently.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: There were 32750 observations read from the data set EPI.RSV_STANDING_COHORT.
WARNING: The data set RF.RSV_STANDING_COHORT may be incomplete. When this step was stopped there were 32749 observations and 9 variables.
ERROR: ROLLBACK issued due to errors for data set RF.RSV_STANDING_COHORT.DATA.
NOTE: DATA statement used (Total process time):
real time 1:35.32
cpu time 0.09 seconds