datetime to character date

[sam369]

Hi All,

I have a variable with numeric datetime, but i need to create a new variable character variable

Have:

subj        stdt(numeric)

100          10OCT2013:12:15:32

want:

subj        stdt(numeric)                                     newvar

100          10OCT2013:12:15:32                     10 OCT 2013

My try:

newvar=scan(put(stdt,datetime20.),1,':');

I got:

10OCT2013

but i want

10 OCT 2013

Thanks

Sam

[art297 · Accepted solution]

data want;

  set have;

  newvar=catx(' ',day(datepart(stdt)),

              upcase(put(month(datepart(stdt)),worddate3.)),

              year(datepart(stdt)));

run;

[sam369]

Thank you Arthur !!! that is what exactly what i am looking for. I tried datepart but i was not succeed with month section.

I got error .. thank you  today i know how to and where to use worddate3. format

Thanks

Sam