topic Re: Need solution for the below dataset in SAS Programming

Need solution for the below dataset

sasuser1 — Tue, 12 Feb 2013 21:57:25 GMT

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?

DBailey — Tue, 12 Feb 2013 22:23:04 GMT

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.

Linlin — Tue, 12 Feb 2013 22:28:13 GMT

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;

Reeza — Tue, 12 Feb 2013 22:32:54 GMT

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;