topic Re: Proc Sql select a null as a datetime informat trouble in SAS Programming

Proc Sql select a null as a datetime informat trouble

ryanb0001 — Thu, 17 Feb 2022 14:02:42 GMT

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

Re: Proc Sql select a null as a datetime informat trouble

PeterClemmensen — Thu, 17 Feb 2022 14:06:47 GMT

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;

Re: Proc Sql select a null as a datetime informat trouble

Kurt_Bremser — Thu, 17 Feb 2022 14:16:51 GMT

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.