Date conversion

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 122
Accepted Solution

Date conversion

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

Christos


Accepted Solutions
Solution
‎10-27-2012 07:24 PM
Respected Advisor
Posts: 3,156

Re: Date conversion

Posted in reply to maroulator

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

View solution in original post


All Replies
Solution
‎10-27-2012 07:24 PM
Respected Advisor
Posts: 3,156

Re: Date conversion

Posted in reply to maroulator

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

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 166 views
  • 0 likes
  • 2 in conversation