Hi All,   Can pls tell me what will be the output for the below logic   count (case when (reg_id in ('03') and 2009-04-30 BETWEEN intnx('month', "2009-07-30"d, -2, 'end')   AND intnx('month', "2009-07-30"d, -13, 'begin')) then 1 else . end) as cust_id ... View more

Hi All,    Can  pls explain the below code. My doubt is    1. var.sec_terc --> is this a table or column name?   2.from DET_CT var  --> What it is actually? If table, above one is column name is it? proc sql; create table CT_M. as select var.sec_terc ,max (case when (var.mod_r in ('01') and var.CAL IN ('P') and FEC_COR_R BETWEEN intnx('month', "&PAR_FEC_H"d, -2, 'end')  AND intnx('month', "&PAR_FEC_H"d, -4, 'begin') and var.edad_m_r>=0) then min(12,var.edad_m_r) else . end) as C_150 from DET_CT var  where var.CALIDAD IN ('P' 'C' 'S' 'A') and var.ESTADO_R not in ('7' '07' ' 7' '7 ' '70') group by var.sec_terc; quit; ... View more

Hi Folks,   Can anyone say what will be  the output for the below code?      %global PR_FA_H PR_F_A PR_F_I PR_F_S PR_T_C PR_TA_C  PR_T_V  PR_T_O  PR_T_OT  PR_TA ENTI DEFINE_ENT PR_SA; %macro autofecha; %let par1=%sysfunc(putn(%sysevalf("&sysdate"d-0),weekday.)); %put par1 = &par1; %if &par1 <= 6 %then %let par2= %sysfunc(putn(%sysevalf("&sysdate"d-(&par1 + 1)),date9.)); %else %let par2= %sysfunc(putn(%sysevalf("&sysdate"d-(1)),date9.)); %put par2=&par2; %let PR_FA_H=%sysfunc(putn(%sysfunc(intnx(month,"%sysfunc(putn("&par2"d,date9.))"d,-0, begin)),date9.)); %let PR_F_A=%sysfunc(putn(%sysfunc(intnx(month,"%sysfunc(putn("&par2"d,date9.))"d,-13, begin)),date9.)); %let PR_F_I=%sysfunc(putn(%sysfunc(intnx(month,"%sysfunc(putn("&par2"d,date9.))"d,-49, begin)),date9.)); %let PR_F_S=%sysfunc(putn(%sysfunc(intnx(month,"%sysfunc(putn("&par2"d,date9.))"d,-7, begin)),date9.)); %put PR_FA_H=&PR_FA_H; %put PR_F_A=&PR_F_A; %put PR_F_I=&PR_F_I; %put PR_F_S=&PR_F_S; %let PR_T_C = 1.2; %let PR_TA_C = 2.0; %let PR_T_V = 1.1; %let PR_T_O = 2.0; %let PR_T_OT = 2.0; %let PR_TA = 2.0; %let ENTI=9999999999;  %let DEFINE_ENT= le;  %let PR_SA=MCDO;  %mend autofecha; %autofecha; ... View more

Can anyone pls explain what actually happen in the below sas script. I am unable to understan .AS in the script.   PROC SQL; CREATE TABLE in.AAAA as SELECT Client AS IDNumber, CIDNumber AS au_IDNumber, . as Emp, BN871, BN562, BN123, BN346, . as MT111, . as MT112, . as MT113, . as MT114, D_host, AXZ_host, TJD_AG, FROM in.PME_SDC; QUIT; ... View more