topic datetime to character date in SAS Procedures

datetime to character date

sam369 — Wed, 01 Oct 2014 22:03:47 GMT

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 — Wed, 01 Oct 2014 22:21:53 GMT

data want;

set have;

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

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

year(datepart(stdt)));

run;

sam369 — Wed, 01 Oct 2014 22:30:35 GMT

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