topic Re: How to format a char date from mm/dd/yy to Month Day, Year in SAS Programming

How to format a char date from mm/dd/yy to Month Day, Year

GreggB — Thu, 04 Apr 2019 23:12:50 GMT

Data I have:

10/22/2005

01/10/2010

Data I want:

October 22, 2005

January 10, 2010

If possible, I would the day of the week for each date. Example: 04/04/2019 becomes Thursday, April 4, 2019

Re: How to format a char date from mm/dd/yy to Month Day, Year

VDD — Thu, 04 Apr 2019 23:40:32 GMT

Data have;
input date $10.;
cards;
10/22/2005
01/10/2010
;

data want;
set have;
new_date=input(date,anydtdte21.);
weekday=input(date,anydtdte21.);
format weekday DOWNAME. new_date worddate.;
run;

Re: How to format a char date from mm/dd/yy to Month Day, Year

novinosrin — Fri, 05 Apr 2019 00:03:53 GMT

Hi @VDD Good answer, but may i ask why are you using anydt informat as opposed to mmddyy informat. No biggie but just wondering

Re: How to format a char date from mm/dd/yy to Month Day, Year

VDD — Fri, 05 Apr 2019 00:14:34 GMT

I used that format in the second date step just because it was usable there. I could have used the mmddyy10. format.

here is a sample where you could have the full request in 1 variable.

data want;
set have;
new_date=input(date,anydtdte21.);
weekday=input(date,anydtdte21.);
one_date = input(date,anydtdte21.);
format weekday DOWNAME. new_date worddate. one_date weekdate.;
run;

Re: How to format a char date from mm/dd/yy to Month Day, Year

Shivam — Fri, 05 Apr 2019 05:09:42 GMT

Try this,

you'll get weekday and date in same column

data want;
set have;
format date WEEKDATX23.;
run;

Re: How to format a char date from mm/dd/yy to Month Day, Year

VDD — Fri, 05 Apr 2019 11:32:50 GMT

@Shivam did your run the code or just read the code?

Re: How to format a char date from mm/dd/yy to Month Day, Year

Shivam — Fri, 05 Apr 2019 11:53:39 GMT

Hi,

I ran your code, that worked fine. why?