topic DATE IS SAVED IN CHARACTER AND I WHAT TO CHANGE IN NUMERIC in New SAS User

DATE IS SAVED IN CHARACTER AND I WHAT TO CHANGE IN NUMERIC

aanan1417 — Wed, 27 Apr 2022 13:46:24 GMT

DATA HAVE;

INPUT DATE $;

DATALINES;

20/11/2017

21/09/2017

;

RUN;

DATA WANT;

INPUT DATE;

DATALINES;

20NOV2017

21SEP2017

;

RUN;

Re: DATE IS SAVED IN CHARACTER AND I WHAT TO CHANGE IN NUMERIC

PaigeMiller — Wed, 27 Apr 2022 14:14:16 GMT

You use the INPUT function, and the proper informat (DDMMYY10.)

data have;
input date $10.;
datalines;
20/11/2017
21/09/2017
;

data want;
    set have;
    numeric_date=input(date,ddmmyy10.);
    format numeric_date date9.;
run;