Need solution for the below dataset

Reply
Occasional Contributor
Posts: 5

Need solution for the below dataset

Data abc;

input start_date $10.;

cards;

2008-06-31

;

run;

I am trying to convert the about date into the date format 31/06/2008.

Could you please any one help in getting this resolved?

Super Contributor
Posts: 578

Re: Need solution for the below dataset

I don't think that's a valid date?  If it was, it should be a simple matter to read it in as a date and apply the ddmmyy10. format.

Super Contributor
Posts: 1,636

Re: Need solution for the below dataset

Hi,

there were only 30 days in June.

Data abc;

input start_date $10.;

cards;

2008-06-30

;

data want;

  set abc;

   new_date=input(start_date,yymmdd10.);

  format new_date ddmmyy10.;

  proc print;run;

Super User
Posts: 17,912

Re: Need solution for the below dataset

Or directly in the input step is possible.

Data abc;

informat start_date yymmdd10.;

format start_date date9.;

input start_date;

cards;

2008-06-30

2008-06-31

2008-07-01

;

run;

Ask a Question
Discussion stats
  • 3 replies
  • 195 views
  • 0 likes
  • 4 in conversation