Folks, thanks again for your assistance. I think I am getting there.
here is my code so far
------------------CODE------------------------------
data _null_; format week comma10.0; format date1 date2 date_today date9.; format date MONYY.;
if 8 <= day(today()) <= 14 then do; week = 1 ; date = intnx('month',today(),0); date1 = intnx('month',today(),0, 'b'); date2 = intnx('month',today(),1, 'b'); date_today = intnx('week',today(),0); end; else if 15 <= day(today()) <= 21 then do; week = 2 ; date = intnx('month',today(),0); date1 = intnx('month',today(),0, 'b'); date2 = intnx('month',today(),1, 'b'); date_today = intnx('week',today(),0); end; else if 22 <= day(today()) <= 31 then do; week = 3 ; date = intnx('month',today(),0); date1 = intnx('month',today(),0, 'b'); date2 = intnx('month',today(),1, 'b'); date_today = intnx('week',today(),0); end; else if 1 <= day(today()) <= 7 then do; week = 4 ; date = intnx('month',today(),-1); date1 = intnx('month',today(),-1, 'b'); date2 = intnx('month',today(),0, 'b'); date_today = intnx('week',today(),0); end;
put date1 date2 date_today DATE9.; put date MONYY.;
call symputx('week',week); call symputx('date',date); call symputx('date1',date1); call symputx('date2',date2); call symputx('date_today',date_today);
run;
%put date = &date. date1 = &date1. date2 = &date2. date_today = &date_today. week = &week.;
--------------------------Log file -----------------------------------------------
5676 else if 5677 1 <= day(today()) <= 7 then 5678 do; 5679 week = 4 ; 5680 date = intnx('month',today(),-1); 5681 date1 = intnx('month',today(),-1, 'b'); 5682 date2 = intnx('month',today(),0, 'b'); 5683 date_today = intnx('week',today(),0); 5684 end; 5685 5686 put date1 date2 date_today DATE9.; 5687 put date MONYY.; 5688 5689 5690 call symputx('week',week); 5691 call symputx('date',date); 5692 call symputx('date1',date1); 5693 call symputx('date2',date2); 5694 call symputx('date_today',date_today); 5695 5696 run;
01MAY2017 01JUN2017 21MAY2017 MAY17 NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds
SYMBOLGEN: Macro variable DATE resolves to 20940 5697 SYMBOLGEN: Macro variable DATE1 resolves to 20940 5698 SYMBOLGEN: Macro variable DATE2 resolves to 20971 5699 SYMBOLGEN: Macro variable DATE_TODAY resolves to 20960 5700 SYMBOLGEN: Macro variable WEEK resolves to 3 5701 %put date = &date. date1 = &date1. date2 = &date2. date_today = &date_today. week = &week.; date = 20940 date1 = 20940 date2 = 20971 date_today = 20960 week = 3
----------------------------------------------------Remaining Issue ---------------------------------------
my date_today is not set up properly
I want date today to be as follows
if today is between 8th day of the month to 14th day of the month: 8th day of the month, as en example 8May2017
if today is between 15th day of the month to 21nd day of the month: 15th day of the month, as en example 15May2017
if today is between 22nd day of the month to 31st day of the month: 22nd day of the month, as en example 22May2017
...
I tried differnet logic as posted above but nothing is work so far, please advise
Thanks again
... View more
