DATA Step, Macro, Functions and more

If date is in this month or not

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 7
Accepted Solution

If date is in this month or not

 

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.

 


Accepted Solutions
Solution
‎12-03-2015 04:59 PM
Super Contributor
Posts: 275

Re: If date is in this month or not

Posted in reply to Mattress58


proc sql;
create table report5 as
select case when ci_month-today()<=0 then 0
else 1 end as w_Month
from mydata;
quit;

View solution in original post


All Replies
Solution
‎12-03-2015 04:59 PM
Super Contributor
Posts: 275

Re: If date is in this month or not

Posted in reply to Mattress58


proc sql;
create table report5 as
select case when ci_month-today()<=0 then 0
else 1 end as w_Month
from mydata;
quit;

Super User
Posts: 19,772

Re: If date is in this month or not

Posted in reply to Mattress58
I think you want intck() function
Occasional Contributor
Posts: 7

Re: If date is in this month or not

Posted in reply to Mattress58

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

Super User
Posts: 19,772

Re: If date is in this month or not

Posted in reply to Mattress58
Try -> diff = intck('month', today(), '01Dec2015'd)+1;
🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 297 views
  • 0 likes
  • 3 in conversation