DATA Step, Macro, Functions and more

Datetime format conversion help

Reply
Contributor
Posts: 44

Datetime format conversion help

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

Super User
Super User
Posts: 7,050

Re: Datetime format conversion help

Posted in reply to yashpande

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

Ask a Question
Discussion stats
  • 1 reply
  • 203 views
  • 0 likes
  • 2 in conversation