topic How to replicate SQL error message in SAS using Proc SQL in SAS Programming

How to replicate SQL error message in SAS using Proc SQL

madhuk — Wed, 03 Feb 2021 15:43:56 GMT

CREATE TABLE Table_1
(
col1 NUMERIC(16, 12)
)

INSERT INTO Table_1
SELECT col1
FROM table_2;

How to replicate above code in SAS using proc SQL? if the length of col1 from table 2 does not matches with

col1 NUMERIC(16, 12) the program should show an error message.

Is it achievable in SAS using proc SQL?

Re: How to replicate SQL error message in SAS using Proc SQL

Kurt_Bremser — Wed, 03 Feb 2021 15:50:35 GMT

SAS has only one datatype for numbers: numeric (8 byte floating point, aka "real"). All numeric types defined in, say SQL, map to this; combining such datasets will work.

Only when you try to mix character with numeric, or character variables with different defined lengths, will you run into problems.