date format change

aanan1417 — Wed, 10 Aug 2022 06:58:39 GMT

data have;

input date $10.;

datalines;

6-Mar-22

;

run;

data want;

input date $10.;

datalines;

06Mar2022

;

run;

Re: date format change

Kurt_Bremser — Wed, 10 Aug 2022 07:11:04 GMT

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.

topic date format change in SAS Programming

date format change

Re: date format change