topic insert year value in a creating table in SAS Programming

insert year value in a creating table

BrahmanandaRao — Mon, 01 May 2023 07:07:48 GMT

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

Re: insert year value in a creating table

Kurt_Bremser — Mon, 01 May 2023 07:53:25 GMT

There is no YEAR informat
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?

Re: insert year value in a creating table

Patrick — Mon, 01 May 2023 09:25:06 GMT

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;