insert year value in a creating table

[BrahmanandaRao]

proc sql;
create table countries (name char(25), Capital char(25), Population num(45), Area num(35), 
Contant char(25), UNDate num informat=year4. format=year4. );
insert into countries values('Afghanistan','Kabul',17070323,251825,'Asia',1946);
quit;

In the above insert UNDate value 1946 problem output it gives 1965

[Kurt_Bremser]

1. There is no YEAR informat
2. Maxim 1: Read the Documentation: YEAR Format Study the documentation closely, and you will see why this conversion happens. Hint: see what kind of data the format expects; in which year is the 1946th day after 1960-01-01?

[Patrick · Accepted solution]

On top of what @Kurt_Bremser said:

Informats on a table don't come into play when using a SQL insert statement. You need already to provide in the insert statement the value that matches the data type.

Informats come into play when using an INPUT statement.

Code below that uses a valid informat to demonstrate what I just wrote.

proc sql;
  create table countries (
    name char(25), 
    Capital char(25), 
    Population num(45), 
    Area num(35), 
    Contant char(25),
    UNDate num informat=date9. 
    );
  insert into countries values('Afghanistan','Kabul',17070323,251825,'Asia','10Mar2023');
quit;