How to replicate SQL error message in SAS using Proc SQL

[madhuk]

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?

[Kurt_Bremser · Accepted solution]

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.