data have;
input date $10.;
datalines;
6-Mar-22
;
run;
data want;
input date $10.;
datalines;
06Mar2022
;
run;
You never (as in NEVER) want to store dates or times as character, as you can't work with them. Read and store them as SAS date and time values in the first place.
data want;
input date :date9.;
format date yymmdd10.; /* use any date format which suits you here */
datalines;
6-Mar-22
;
Dates are counts of days, starting with 1960-01-01 as day zero, going back to 1582 (the introduction of the Gregorian calendar) and forward to at least 9999-12-31.
Times are counts of seconds, starting at midnight, or 1960-012-01T00:00:00 for datetimes.
You never (as in NEVER) want to store dates or times as character, as you can't work with them. Read and store them as SAS date and time values in the first place.
data want;
input date :date9.;
format date yymmdd10.; /* use any date format which suits you here */
datalines;
6-Mar-22
;
Dates are counts of days, starting with 1960-01-01 as day zero, going back to 1582 (the introduction of the Gregorian calendar) and forward to at least 9999-12-31.
Times are counts of seconds, starting at midnight, or 1960-012-01T00:00:00 for datetimes.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.