Date conversion

maroulator — Sat, 27 Oct 2012 21:18:12 GMT

I have a variable DATE that has a value of 2012-04-05. How do I convert that value into 05Apr2012?

Christos

Re: Date conversion

Haikuo — Sat, 27 Oct 2012 23:24:20 GMT

Hi,

From your description, it is difficult to tell whether you want to change format for a numeric variable(dt1) or you want to make change on a character variable(dt2). Any way, the following example addressed both.

data have;

input dt1 yymmdd10. @1 dt2 $10.;

format dt1 yymmdd10.;

cards;

2012-04-05

run;

data want;

set have;

format dt1 date9.;

dt2=put(input(dt2,yymmdd10.),date9.);

run;

proc print;run;

Haikuo

topic Date conversion in SAS Programming

Date conversion

Re: Date conversion