About amanegm

amanegm · ‎12-22-2017

Yes, I want to create this table for a report. This looks very clean and easier to understand. Thank you so much.

amanegm · ‎12-21-2017

Hi. I want to convert BY group rows into several columns based on Month values and Booking Type. Based on AID and SID, I want to create different columns containing order quantity representing Month and BK_Code such as M1_D_Order for Month '1' and BK_Code 'D' M2_D_Order for Month '2' and BK_Code 'D' M3_D_Order for Month '3' and BK_Code 'D' Similarly for other 3 BK_Code - 'W', 'B' and 'M'. Here I have data for 3 months. Hence there should be 3 x 4 = 12 columns representing the order quantity in respective columns for Month and BK_Code. Later, I have to expand for 12 months (12*4 = 48 columns). Subsequently, each row will be a unique combination of AID and SID. My data looks like this: AID SID Booking BK_Code Month Order Revenue 1 10 0 - 6 Nights D 1 3 149.97 1 10 15 - 29 Nights B 1 76 3105.49 1 10 15 - 29 Nights B 3 57 2627.22 1 10 30+ Nights M 1 0 0 1 10 7 - 14 Nights W 2 44 2227.32 1 13 0 - 6 Nights D 3 7 584.93 1 13 7 - 14 Nights W 3 42 2593.08 1 17 0 - 6 Nights D 2 2 194.73 1 17 7 - 14 Nights W 2 27 1932.03 1 18 7 - 14 Nights W 3 12 863.88 1 18 7 - 14 Nights W 1 4 287.96 2 20 30+ Nights M 2 17 1377 2 20 30+ Nights M 3 30 2088 2 25 15 - 29 Nights B 2 30 1367.7 2 25 15 - 29 Nights B 3 15 683.85 2 25 7 - 14 Nights W 2 9 410.31 2 25 7 - 14 Nights W 3 5 227.95 Expected Result: AID SID M1_D_Order M2_D_Order M3_D_Order M1_W_Order M2_W_Order M3_W_Order M1_B_Order M2_B_Order M3_B_Order M1_M_Order M2_M_Order M3_M_Order 1 10 3 44 76 57 0 1 13 2 7 42 1 17 2 27 1 18 4 12 2 20 17 30 2 25 9 5 30 15 Thanks in advance.

amanegm · ‎01-31-2017

Thank you Rick. That was very helpful. DFFITS is not available in Proc Genmod. But is it correct to use DFFITS in Proc Genmod, if I calculate it by some other means. I am using Log Link function. Also, in R, if I build similar model as below: l = glm(resp[[1]] ~ unlist(regr[[1]]) , family="poisson") DFFITS function is available to compute that statistic. So I am confused if it the right way?

amanegm · ‎01-31-2017

Hi All, I am trying to use Proc Genmod to build Count Regression Model on Poisson. I have written the code as below: proc genmod data = COUNT_data; model count = KM /dist = poisson; output out = outpt predicted = pred_val resdev = r_dev; run; Here I have tried to output the predicted values, deviance residual in variables pred_val, r_dev respectively in the output dataset - outpt. Output of this proc executed is as below: The SAS System The GENMOD Procedure Model Information Data Set WORK.COUNT_DATA Distribution Poisson Link Function Log Dependent Variable Count Number of Observations Read 222 Number of Observations Used 222 Criteria For Assessing Goodness Of Fit Criterion DF Value Value/DF Deviance 220 170.1860 0.7736 Scaled Deviance 220 170.1860 0.7736 Pearson Chi-Square 220 199.7315 0.9079 Scaled Pearson X2 220 199.7315 0.9079 Log Likelihood -91.0389 Full Log Likelihood -371.0120 AIC (smaller is better) 746.0240 AICC (smaller is better) 746.0788 BIC (smaller is better) 752.8294 Algorithm converged. Analysis Of Maximum Likelihood Parameter Estimates Parameter DF Estimate Standard Error Wald 95% Confidence Limits Wald Chi-Square Pr > ChiSq Intercept 1 0.5680 0.1108 0.3508 0.7852 26.27 <.0001 KM 1 0.0000 0.0000 0.0000 0.0000 6.08 0.0137 Scale 0 1.0000 0.0000 1.0000 1.0000 I want to save the Deviance (170.1860 as in the above output) in some variable/dataset. How can it be done? Also, How to calculate DFFITS? I want to find such observations where DFFITS > 2 * sqrt(2/n). I have seen that DFBETAS is available as an Output Statment option. On similar lines, is DFFITS available too?

amanegm · ‎11-24-2016

Hi SAS Users, I am not able to find the ID which has negative values within the BY group. Let me explain. My data looks like below: ID Value 100 1792 100 68193 100 -66173 100 1012 100 -366 101 -580 101 296 101 -37 102 13008 102 -205 102 2808 102 1185 So I want to identify all such ID's which, having one or more negative values within the BY group, then all should be within the range -1000 to -1. Here ID 100 has a value -366 but it also has -66173. So I dont want to select this. All the negative values within the BY group should be within the above limit. ID 101 has two negative values -580 & -37 and both lie in the limit so I will select ID 101. Also, for ID 102 it has only one negative value, -205. Hence I will select it as it lies in the given range. Further, I need to differentiate between the selected ID's which have one or more negative values within the limit. Count of negative values within the limit would be helpful.

Online Status	Offline
Date Last Visited	‎01-24-2018 12:03 AM

Re: How to convert By group rows in to different columns?

How to convert By group rows in to different columns?

Re: How to get Residual Deviance and DFFITS using proc genmod

How to get Residual Deviance and DFFITS using proc genmod

Find the By group with values within a limit

Re: How to get Residual Deviance and DFFITS using proc genmod

Re: How to convert By group rows in to different columns?

How to convert By group rows in to different columns?

Re: How to get Residual Deviance and DFFITS using proc genmod

How to get Residual Deviance and DFFITS using proc genmod

Find the By group with values within a limit