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

[aanan1417]

DATA HAVE;

INPUT DATE $;

DATALINES;

20/11/2017

21/09/2017

;

RUN;

DATA WANT;

INPUT DATE;

DATALINES;

20NOV2017

21SEP2017

;

RUN;

[PaigeMiller · Accepted solution]

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;