date format change

[aanan1417]

data have;

input date $10.;

datalines;

6-Mar-22

;

run;

data want;

input date $10.;

datalines;

06Mar2022

;

run;

[Kurt_Bremser · Accepted solution]

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.