How can I create add a column and if the ci_month date below is in this month then put a 0 and if it is in next month put a 1 and call the column W_Month
proc sql;
create table report5 AS SELECT
ci_month
from mydata
; quit;
example if today's date is 12/3/2015 and ci_month 20423 (which is 12/1/2015) then W_Month would be 1. If ci_month was 20454 (which is 1/1/2016) then W_Month would be 2.
proc sql;
create table report5 as
select case when ci_month-today()<=0 then 0
else 1 end as w_Month
from mydata;
quit;
proc sql;
create table report5 as
select case when ci_month-today()<=0 then 0
else 1 end as w_Month
from mydata;
quit;
I came up with this
,case
when ci_month between INTNX('MONTH',TODAY(),0,'B') and INTNX('MONTH',TODAY(),0,'E') then 1
when ci_month between INTNX('MONTH',TODAY(),1,'B') and INTNX('MONTH',TODAY(),1,'E') then 2
when ci_month between INTNX('MONTH',TODAY(),2,'B') and INTNX('MONTH',TODAY(),2,'E') then 3
when ci_month between INTNX('MONTH',TODAY(),3,'B') and INTNX('MONTH',TODAY(),3,'E') then 4
when ci_month between INTNX('MONTH',TODAY(),4,'B') and INTNX('MONTH',TODAY(),4,'E') then 5
when ci_month between INTNX('MONTH',TODAY(),5,'B') and INTNX('MONTH',TODAY(),5,'E') then 6
else 0 end as mth_lst
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.