How can I convert char to date in proc sql?

seohyeonjeong — Thu, 25 Nov 2021 06:48:17 GMT

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;

Re: How can I convert char to date in proc sql?

ChrisNZ — Thu, 25 Nov 2021 07:11:48 GMT

Like this?

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