SAS Date

[Reader587]

How do I change the dates 

9/2001

11/2000

1/2011

 to 

9/15/2001

11/15/2000

1/15/2011 ?

There are many more dates in format mm/yyyy and I want to change them to mm/15/yyyy. 

[SASKiwi · Accepted solution]

data _null_;
  month_string = '9/2001';
  SAS_Date = mdy(input(scan(month_string,1),2.),15,input(scan(month_string,2),4.));
  format SAS_Date mmddyys10.;
  put _all_;
run;

[Reader587]

Thank You.

[Tom]

Just prefix the string with 15/ and use the DDMMYY informat.

data have;
  input string $10.;
cards;
9/2001
11/2000
1/2011
;

data want;
  set have;
  date=input(cats('15/',string),ddmmyy10.);
  format date yymmdd10.;
run;

proc print;
run;

Obs    string           date

 1     9/2001     2001-09-15
 2     11/2000    2000-11-15
 3     1/2011     2011-01-15

PS Display dates in DMY or MDY order will confuse 50% of your audience. Use YMD order or the DATE format.