Convert char YYYY-MM into sas date

Ronein — Mon, 19 Dec 2022 06:18:48 GMT

Hello

What is the correct informant to convert sas char(structure YYYY-MM) into sas date ?

DATA t;
char_var = '2022-10';
date=input(char_var,yymmd7.);
format date DDMMYY10.;
RUN;

The error is :

28 date=input(char_var,yymmd7.);
_______
485
NOTE 485-185: Informat YYMMD was not found or could not be loaded.

Re: Convert char YYYY-MM into sas date

Kurt_Bremser — Mon, 19 Dec 2022 06:33:53 GMT

Use the COMPRESS function to get rid of the hyphen, after which the YYMMN6. informat will work.