Hello For each customer I have 12 rows (12 months data) with information of current account balance. I want to calculate for each customer:  Maximum number of months with negative balance in a row (It means that month after month had negative balance). In this example: Customer 111 has 3 months in row with negative balance Customer 222 has 0 months in row with negative balance What is the way to calculate it in sas please ? Please see a code that calculate it well but maybe there is other nice code  ? data have; input CustID YYYYMM balance; IF balance<0 then Ind_Neg=1;else Ind_Neg=0; cards; 111 2020401 1000 111 2020402 -4000 111 2020403 1000 111 2020404 1900 111 2020405 -1000 111 2020406 -2000 111 2020407 5000 111 2020408 6000 111 2020409 -2000 111 2020410 -3000 111 2020411 -4000 111 2020412 8000 222 2020401 3000 222 2020402 4000 222 2020403 1000 222 2020404 5000 222 2020405 8000 222 2020406 7800 222 2020407 5000 222 2020408 3000 222 2020409 1000 222 2020410 2000 222 2020411 1000 222 2020412 7000 ; Run; proc sort data=have; by CustID YYYYMM; run; data want1; set have; by CustID; retain Accum_Nr_Neg; if first.CustID then Accum_Nr_Neg=Ind_Neg; else Accum_Nr_Neg+Ind_Neg; run; data want2; set have; by CustID; retain Accum_Nr_Neg_in_Row; if first.CustID then Accum_Nr_Neg_in_Row=Ind_Neg; else Accum_Nr_Neg_in_Row=sum(Accum_Nr_Neg_in_Row,Ind_Neg)*Ind_Neg; run; proc sql; create table want3 as select CustID, max(Accum_Nr_Neg_in_Row) as max_Accum_Nr_Neg_in_Row from want2 group by CustID ; quit; ... View more

Hello Here is my code. What is wrong with my code. I want to perform data step statements based on condition on macro var  (The macro var is defined by user and get value 1 or 0)   Data have; input custID X; cards; 1 10 3 30 ; Run; %let ind_OOT=1; /*%let ind_OOT=0;*/ %macro My_Macro; %IF &ind_OOT.=1 %THEN %DO; Data have; set have; Ind_out_sample=0; outsample=0; Run; %ELSE %DO; Data have; set have; Run; %END; %MEND My_Macro; %My_Macro Here is Log error 1 The SAS System 12:24 Thursday, December 19, 2024 1 ;*';*";*/;quit;run; 2 OPTIONS PAGENO=MIN; 3 %LET _CLIENTTASKLABEL='Program (4)'; 4 %LET _CLIENTPROCESSFLOWNAME='Process Flow'; 5 %LET _CLIENTPROJECTPATH=''; 6 %LET _CLIENTPROJECTPATHHOST=''; 7 %LET _CLIENTPROJECTNAME=''; 8 %LET _SASPROGRAMFILE=''; 9 %LET _SASPROGRAMFILEHOST=''; 10 11 ODS _ALL_ CLOSE; 12 OPTIONS DEV=PNG; 13 GOPTIONS XPIXELS=0 YPIXELS=0; 14 FILENAME EGSR TEMP; 15 ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR 16 STYLE=HTMLBlue 17 STYLESHEET=(URL="file:///C:/Program%20Files/SASHome/SASEnterpriseGuide/7.1/Styles/HTMLBlue.css") 18 NOGTITLE 19 NOGFOOTNOTE 20 GPATH=&sasworklocation 21 ENCODING=UTF8 22 options(rolap="on") 23 ; NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR 24 25 GOPTIONS ACCESSIBLE; 26 %let ind_OOT=1; 27 28 %macro My_Macro; 29 %IF &ind_OOT.=1 %THEN %DO; 30 Data have; 31 set have; 32 Ind_out_sample=0; 33 outsample=0; 34 Run; 35 %ELSE %DO; ERROR: There is no matching %IF statement for the %ELSE. ERROR: A dummy macro will be compiled. 36 Data have; 37 set have; 38 Run; 39 %END; 40 %MEND My_Macro; 41 %My_Macro _ 180 WARNING: Apparent invocation of macro MY_MACRO not resolved. ERROR 180-322: Statement is not valid or it is used out of proper order. 42 43 GOPTIONS NOACCESSIBLE; 44 %LET _CLIENTTASKLABEL=; 45 %LET _CLIENTPROCESSFLOWNAME=; 46 %LET _CLIENTPROJECTPATH=; 47 %LET _CLIENTPROJECTPATHHOST=; 48 %LET _CLIENTPROJECTNAME=; 49 %LET _SASPROGRAMFILE=; 2 The SAS System 12:24 Thursday, December 19, 2024 50 %LET _SASPROGRAMFILEHOST=; 51 52 ;*';*";*/;quit;run; 53 ODS _ALL_ CLOSE; 54 55 56 QUIT; RUN; 57   ... View more

Hello Let's say that  there is a data set with required formula to apply. What is the way to appy the formula that in the data set on other data set? Data have; input x y z; cards; 10 20 30 15 20 200 10 30 40 ; run; data formula_tbl; input formula $; cards; x+y-0.1*x ; run; proc sql; create table t1 as select * from have,formula_tbl ; quit; data want; set t1; calc=formula; run; ... View more

Hello friends , I have train data, test data, out of time data. There are 3 things I want to do- 1-calculate model coefficients based on train data  2-calculate pred valued for each observation train+test data 3-calculate pred valued for each observation in out of time data   What is the way to perform task 3 using proc genmod ?   Please note that I tried to save the coefficients in a permanents data set (permanent  library) but I cannot find this data set proc genmod data=panel; ods output parameterestimates=tbl_coefficients;/****Data set with Coeficients information that was calculated from train data only****/ weight weight; model y=x / dist=binomial link=logit type3 wald ; output out=preds_tbl pred=P_BAD XBETA=logit; store R_R.coefficients; Run;     Data train(KEEP=X Y); Do i=1 to 50; x=ranuni(1234579); p = 0.6; u = rand("Uniform"); if (u < p) then Y=1;else Y=0; output; end; Run; Data test(KEEP=X Y); Do i=1 to 25; x=ranuni(1234579); p = 0.6; u = rand("Uniform"); if (u < p) then Y=1;else Y=0; output; end; Run; data panel; set train(in=a) test(in=b); if a then weight=1;else weight=0;/***Value 1 for train data, value 0 for test data**/ Run; proc genmod data=panel; ods output parameterestimates=tbl_coefficients;/****Data set with Coeficients information that was calculated from train data only****/ weight weight; model y=x / dist=binomial link=logit type3 wald ; output out=preds_tbl pred=P_BAD XBETA=logit; Run; Data Out_of_time; Do i=1 to 200; x=ranuni(1234579); p = 0.6; u = rand("Uniform"); if (u < p) then Y=1;else Y=0; output; end; Run; /**I want to calculate pred on this data of out of time***/       ... View more