Hi All, I am new to SAS. I am trying to extract data from SQL Server and load into Teradata. My source table has few columns which are converted to 'yyyy-mm-dd' format and loaded to Teradata in the PROC sql. when I am trying to append the dataset to Teradata, it gives me a warning: WARNING: Variable OPPORTUNITY_TCV not appended because of type mismatch. From source I am extracting it as below: FORMAT(CAST([Status Change Date] AS DATETIME),'yyyy-MM-dd') AS [STATUS_CHANGE_DATE], In the destination DB (Teradata) the column is defined as: STATUS_CHANGE_DATE DATE FORMAT 'YYYY-MM-DD' DEFAULT DATE '2000-01-01', while executing the SAS program I am getting the below warning. WARNING: Variable STATUS_CHANGE_DATE not appended because of type mismatch. Please suggest how I can resolve the warning.
... View more