Hello guys! I have a question and I need your help. I have a PROC IMPORT of a worksheet in Excel that may or may not have records in all columns. After importing this data, I make some treatments and I need to insert the records into an Oracle table. As the records after import assume any format, I need format my variables for after insert in Oracle, but as some variables are null I received this error message: "The character expression requires a character format". Would anyone have a solution for how much do I need to format columns that may or may not contain data to insert into an Oracle table? This is part of my cod SAS: PROC SQL;
INSERT INTO ORACLE.PROD_TABLE
SELECT COD_CUPOM_DESCONTO,
COD_CAMPANHA_DESCONTO,
NME_CUPOM_DESCONTO,
NUM_CPF_CNPJ_SEGDO FORMAT $CHAR18. ,
NUM_CEP_INI FORMAT 9., NUM_CEP_FIM FORMAT 9.,
SIG_FABRIC FORMAT $CHAR5.,
COD_TIPO_CONTR FORMAT 4.,
SIG_TIPO_DOC_COBR FORMAT $CHAR6.
FROM WORK.INSERIR_ORACLE;
QUIT;
... View more