topic Re: Change CHAR "202101" into DATE format YYMMDD10. in SAS Programming

Change CHAR "202101" into DATE format YYMMDD10.

PatrykSAS — Thu, 25 Mar 2021 11:55:54 GMT

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?

Re: Change CHAR "202101" into DATE format YYMMDD10.

maguiremq — Thu, 25 Mar 2021 12:17:00 GMT

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;

Re: Change CHAR "202101" into DATE format YYMMDD10.

Kurt_Bremser — Thu, 25 Mar 2021 12:18:48 GMT

There's a dedicated informat for this:

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