Thank you Reeza. That is  something interesting to incorporate a population growth. Do you have anything link /articles to share. I would love to explore more.   ... View more

Hi , I did put the job code in the  model.(please see below)  with this model I need to showcase the business case that " the average productivity has to increase  to X  inorder to increase the # of closes (cc) by 20% something like that. So that they will set a benchmark in future that each employee has to work this way ( in terms of average productivity) to get the goal of 20% or something.   Any other  way to  analyse that statement? or do you recommend any book that optimize this kind of resources/analysis I appreciate you and  your time. proc gee data=GEE; CLASS EMPLID JOBCODE(PARAM = REF REF="RN"); model CC= JOBCODE | AVERAGEPRODUCTIVITY / dist=nb; repeated subject=emplID / type=exch; run; ... View more

hi I got this results as I am not sure  how do i know if this is good model. I usually interpretate it with AIC, BIC.   Also  please help me interpretate the estimates in easy unit as it is giving me in logit. Thank you so much   Data SetWORK.GEEModel Information Distribution Negative Binomial Link Function Log Dependent Variable CC Correlation StructureExchangeableGEE Model Information Subject Effect EMPLID (35 levels) Number of Clusters 35 Clusters With Missing Values 20 Correlation Matrix Dimension 26 Maximum Cluster Size 26 Minimum Cluster Size 0 Correlation0.3306Exchangeable Working Correlation QIC-39286.1120GEE Fit Criteria QICu -39320.8443 Intercept 1.31570.12921.06261.568810.19<.0001Parameter Estimates for Response Modelwith Empirical Standard Error EstimatesParameter   Estimate StandardError 95% Confidence Limits Z Pr > |Z| JOBCODE CAS 0.7825 0.2623 0.2685 1.2965 2.98 0.0028 AVERAGEPRODUCTIVITY   1.6389 0.1727 1.3004 1.9774 9.49 <.0001 AVERAGEPRODU*JOBCODE CAS -1.4072 0.1766 -1.7534 -1.0610 -7.97 <.0001   ... View more

Thank you PG . This helped a lot.  Based on the model results,  I am not sure the reliability of my model.  Even I have a  individual level data I summed it up by pay period data  in the current model. I believe this could be the reason. As I would like to try to fit the model as repeaded subject as each employee have data per pay period data which is  counted 26 times in a year (biweekly pay)  which is described as:  employeeID      payperiod     #closecases          #averageproductivity    Jobtype 1                         1                         24                           1.2                         RN 1                          2                        15                          0.5                          RN 1                         3                         14                          0.9                          RN .                           .                           .                             .                                . 1                         26                        25                          1.2                          RN 2                        1                           56                          1.9                       CLINICAL 2                        2                            54                         1.8                       CLINICAL .                          .                              .                          .                                 .   and so on.. what I  would like to know are following: 1. if close cases count is associated with jobtype. If so What is the magnitude ? 20% more....2 times etc? 2. is there an association of averageproductivity in close cases. if so  how strong  3.what is the influence of adding 2 RN nurse in close cases? 4.what is the influence of adding 5 clinical in closing cases.     Please help how to answer these question in the given code or please advise the best model to answer those questions. proc genmod data=TEST; CLASS JOBtype(PARAM = REF REF="RN"); model CC= JOBTYPE  AVERAGE PRODUCTIVITY JOBCODE*AVERAGEPRODUCTIVITY  /dist=nb link=log scale =p;; run;       ... View more

Great guidance Astounding. It might help me move forward to the article n my  data prep. I sent my friend to run it and she said it works. Thank you so very much  ... View more

i could but I will have sas anyway in few days... This ask was just to follow along to the article and to do that I need to understand the dataset layout.If I could have option to wait then why would I work on sunday evening 🙂 ( plus 20 months son) ... View more

Also i have reached out to author and have not heard back from him yet. ... View more

Thank you Astounding. I am no knowledge of macro so I do not know. The article says that this is the code used to generate the data used in this article. If you could just give me how the data is arranged with the variable name used  in the code above that would be very very helpful to follow along the article and to do same analysis using my data. So based on the code below, it looks like we just need three variables, 1. cotype, 2. emps and 3. calls is this as simple as : cotype    emps               calls a            50                     120 b           200                    130 ... and so one?   proc univariate data=CallsPerHour normal; by CoType emps; var calls; histogram calls /midpoints =1 to 15 by 1; run; run; %mend generate; %generate(EmpCount=%str(1000, 3000, 5000,10000 ) ,AvgCoLambda=8 ,UserGrpLambda=5 ,MaxRepeats=50 ); ... View more

Reeza, This is not for any commercial use . I am genuinely asking for help and I would like to at least  prepare for my data the way it is in this article.I hope you understand my situation. ... View more