How to convert string to date format YYMM

PatrykSAS — Tue, 17 Nov 2020 14:16:25 GMT

Hi,

I wonder how to convert char into date. I have a variable 'DATE' in character format like below

DATE

2020.06

I need to convert this to 2020-06 in date format

I've tried input(t1.DATA,YYMMd.) hopeless what I got is '13JUL1965'

Can you help me with solution?

Re: How to convert string to date format YYMM

PaigeMiller — Tue, 17 Nov 2020 14:18:51 GMT

data want;
    chardate='2020.06';
    numdate=input(compress(chardate,'.'),yymmn6.);
    format numdate yymmd8.;
run;