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.) ;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.