Change CHAR "202101" into DATE format YYMMDD10.

[PatrykSAS]

Hello,

I would like to change char variable like "202101" to date in YYMMDD10. format (2021-01-01)

I tried input(DATE,YYMMDD10.) which returns "."

How to solve that?

[maguiremq · Accepted solution]

Assuming you want the first of the month, this should work. Use CATT to append an "01" or whatever day that you want.

data have;
input date $;
datalines;
202001
202002
199111
;
run;

data want;
	set have;
	format date_test yymmdd10.;
		date_test = input(catt(date, "01"), yymmdd10.);
run;

[Kurt_Bremser]

There's a dedicated informat for this:

data check;
chardate = "202101";
format numdate yymmdd10.;
numdate = input(chardate,yymmn6.);
run;