I want to find First day of current month, Previous month , Next month as the below code is getting an error Data test; date="02DEC2022"d; Frstday=Intnx("date",date,0); run;
... View more
DATA output; set input; if mCX_Tier=1 then default_plan=ceil(4/tgt_cnt); else if mCX_Tier=2 then default_plan=ceil(3/tgt_cnt); else if mCX_Tier=3 then default_plan=ceil(1/tgt_cnt); else IF mCX_Tier=4 THEN default_plan=0; if pSG_Tier=1 then default_plan=plan(3/tgt_cnt); else if pSG_Tier=2 then default_plan=ceil(2/tgt_cnt); else if pSG_Tier=3 then default_plan=ceil(1/tgt_cnt); else IF pSG_Tier=4 THEN default_plan=0; run; here tgt_cnt is 1 So this code is not working for me As tier is getting overlapped e.g- mCX_Tier=1 is getting overlapped with pSG_Tier=3 What I am trying to do is then there is two column p1 and p2 and also we required minimum tier other than below conditon MCX FALLS IN 1/2 then P1 should have MCX and PSG should get into P2 and PSG falls in 3 and MCX FALLS in 4 THEN P1 will get TSG and P2 get SCX
... View more
DATA output; set input; if mCX_Tier=1 then default_plan=ceil(4/tgt_cnt); else if mCX_Tier=2 then default_plan=ceil(3/tgt_cnt); else if mCX_Tier=3 then default_plan=ceil(1/tgt_cnt); else IF mCX_Tier=4 THEN default_plan=0; if pSG_Tier=1 then default_plan=plan(3/tgt_cnt); else if pSG_Tier=2 then default_plan=ceil(2/tgt_cnt); else if pSG_Tier=3 then default_plan=ceil(1/tgt_cnt); else IF pSG_Tier=4 THEN default_plan=0; run; here tgt_cnt is 1 So this code is not working for me As tier is getting overlapped e.g- mCX_Tier=1 is getting overlapped with pSG_Tier=3 What I am trying to do is then there is two column p1 and p2 and also we required minimum tier other than below conditon MCX FALLS IN 1/2 then P1 should have MCX and PSG should get into P2 and PSG falls in 3 and MCX FALLS in 4 THEN P1 will get TSG and P2 get SCX
... View more
So to provide you the answer for why. I need to explain you the explanation whole process of where and what is . Hey man I am just new guy working in SAS tool had a little bit of experience not so much just fumbled on one of the code where I need to replace . to 9 .its simple as that to tell you the truth some of your why question i didn't even get But yeah Thank you very much for you Answer
... View more
Hey Tom Thanks. For me its usable data . To answer your question All the data will get drop in further process wherever it contains 9 . I am making it 9 so the other data dont get messed up before the code was changing all of the variable to 9 which i dont required
... View more
