topic Datetime format conversion help in SAS Programming

Datetime format conversion help

yashpande — Sat, 21 Sep 2013 05:20:01 GMT

Hi All,

I have a macro variable which is coming from oracle table. I want to use that in SAS proc sql but somehow unable to get it. Please help

%put &enddt;

22sep2013 00:00:00

and then when i use

proc sql;

create tablen new as

select &enddt as enddt format datetime20.;

quit;

but this fails. Need help

but

Tom — Mon, 23 Sep 2013 21:13:48 GMT

You need to use a datetime literal, but I don't think you can use that syntax in SQL as you have no FROM clause.

Here is how to do it with a data step.

data new;

enddt = "&enddt"dt ;

format enddt datetime20.;

run;

To make a literal using SAS you follow the value in quotes with the special letter for the type of literal. Common literals are:

t -> Time

d -> Date

dt -> DateTime

x -> Hexadecimal

b -> Binary