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;
Like this?
select
*
from ACTR01
where input("&startdate", yymmn6.) <= input(MLYYN, yymmn6.) <= input("&enddate", yymmn6.) ;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.