Proc Sql select a null as a datetime informat trouble

[ryanb0001]

hello,

its necessary for me to select a null as a datetime. my code:

proc sql

create table work.checking as

select

filenumber,

. as datecolumnname format=datetime26.7 informat=datetime26.7.,

customername,

address

from table

;

QUIT;

i think my trouble is with the informat part, why isn't this working? i get an error that it expects a quoted string

[PeterClemmensen · Accepted solution]

You're missing a semicolon after the Proc SQL Statement. 

Otherwise, no problem :

proc sql;
   select *, 
          . as datecolumnname format=datetime26.7 informat=datetime26.7
   from sashelp.class
   ;
quit;

[Kurt_Bremser]

As mentioned, your PROC SQL statement misses the semicolon.

Informats are only needed when reading from external data, which you never do here, so the INFORMAT= option can be safely omitted.