How can I convert char to date in proc sql?

[seohyeonjeong]

Hi everyone,

I have a data set that has a column named MLYYM.

MLYYM has characters like 201801 (length 6).

I want to convert this column to date with format yyyymm.

I have to make where condition to compare this column value with macro variables(start date and end date)

ex. I have to subtract the data that MLYYM is between the start date(201601) and the end date(202112: this year's end month) 

Code below is what I tried. Could you help this out? 

PROC SQL;

    CREATE TABLE TEST as 

    SELECT 

        compress(MLYYM,'') as date1    /* return length 6 character*/

        ,input(compress(MLYYN, ''), yymmn6.) as date2. /*return length 8 numeric*/

    FROM actr01;

QUIT;

[ChrisNZ]

Like this?

select
  *
from ACTR01
  where  input("&startdate", yymmn6.)  <= input(MLYYN, yymmn6.) <=  input("&enddate", yymmn6.) ;