topic SAS Date in SAS Programming

SAS Date

Reader587 — Tue, 27 Jun 2023 02:13:08 GMT

How do I change the dates

9/2001

11/2000

1/2011

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.

Re: SAS Date

SASKiwi — Tue, 27 Jun 2023 02:49:00 GMT

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;

Re: SAS Date

Reader587 — Tue, 27 Jun 2023 02:56:47 GMT

Thank You.

Re: SAS Date

Tom — Tue, 27 Jun 2023 03:14:36 GMT

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.