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
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.