Hi, i need help in allocating score bands to the corresponding save_ratio.. i tried the below code but it returns null values 'dot' in the output  "Saves_Ratio_Score'   data retentions; input Save_Ratio user : $20. Band_Indicator $; datalines; 0.45 ALUPIYA I 0.37 DLOUIS I 0.6 DMORAKE I 0.30 FDANISA O 0.50 FFARAO O ; proc format; invalue inbound_ratio_band low -< 0.35 = 0 0.35 -< 0.43 = 0.08 0.43 -< 0.473 = 0.16 0.473 -< 0.52 = 0.24 0.52 -< 0.59 = 0.32 0.59 - high = 0.4 ; run; proc format; invalue outbound_ratio_band low -< 0.34 = 0 0.34 -< 0.41 = 0.08 0.41 -< 0.45 = 0.16 0.45 -< 0.5 = 0.24 0.5 -< 0.56 = 0.32 0.56 - high = 0.4 ; run; data fix_bands; SET retentions; IF UPCASE(Band_Indicator) = 'I' THEN Saves_Ratio_Score = INPUT(Save_Ratio,Inbound_ratio_band.); ELSE IF UPCASE(Band_Indicator) = 'O' THEN Saves_Ratio_Score = INPUT(Save_Ratio,Outbound_ratio_band.); CALL MISSING(Saves_Ratio_Score); run;   ... View more

Hi, I need help in allocating score bands to outbound and inbound users based on their QA_Score from retentions table, please note that the last two users FDANISA and FFARAO need to be allocated only outbound_save_band values and first 3 users needs to be only allocated the inbound_save_band value.    data retentions; input QA_score user $20.; datalines; 114 ALUPIYA 130 DLOUIS 150 DMORAKE 100 FDANISA 122 FFARAO ; proc format; invalue inbound_save_band low -< 114 = 0 114 -< 137 = 0.08 137 -< 152 = 0.16 152 -< 167 = 0.24 167 -< 190 = 0.32 190 - high = 0.4 ; run; proc format; invalue outbound_save_band low -< 82 = 0 82 -< 98 = 0.08 98 -< 109 = 0.16 109 -< 120 = 0.24 120 -< 136 = 0.32 136 - high = 0.4 ; run;         data want QA_Score         user            inbound_outbound_score 114                ALUPIYA            0 130               DLOUIS              0.08 150               DMORAKE         0.16 100               FDANISA            0.16 122               FFARAO             0.32 ... View more

Hi , I need help in summing up leave_days monthly for each user, and if the user did not take for leave on a particular calender_month, 0 value should display from the leave_days column corresponding to the calender_month which they did not take leave   Note that if user did not take leave, there will be no record on the leave table and if for example user took 2 days  leave on the same calender_month, then 2 separate records for the same calender_month with will appear in the leave table.                                                                                                                    Data Have data users; input users $50.; datalines; Andrew Lup Mike Mora Farren Seb ; data leave; input calender_month leave_days username $50.; datalines; 202101 1 Andrew Lup 202101 1 Andrew Lup 202102 1 Andrew Lup 202107 1 Andrew Lup 202101 1 Mike Mora 202101 1 Mike Mora 202101 1 Mike Mora 202107 1 Mike Mora 202107 1 Mike Mora ;                                            data want   calender_month           username            leave_days 202101                        Andrew Lup               2 202102                        Andrew Lup               1 202103                       Andrew Lup                0 202104                       Andrew Lup                0 202105                       Andrew Lup                0 202106                       Andrew Lup                0 202107                       Andrew Lup                1 202101                       Mike Mora                  3 202102                       Mike Mora                  0 202103                       Mike Mora                  0 202104                       Mike Mora                  0 202105                       Mike Mora                  0 202106                       Mike Mora                  0 202107                       Mike Mora                  2 202101                       Farren Seb                 0 202102                       Farren Seb                 0 202103                       Farren Seb                 0 202104                       Farren Seb                 0 202105                       Farren Seb                 0 202106                       Farren Seb                 0 202107                       Farren Seb                 0   ... View more

Hi, i need help in imputing categoriacla variables.. i tried below code but im not sure which value to use on the 'method' option...i have a variable called 'marital status' consistin of values 'single, married,widowed'...i need to do something like mode imputation   proc stdize data=data out=Imputed oprefix=Orig_ /* prefix for original variables */ reponly /* only replace; do not standardize */ method=; /*ABW, AGK, AHUBER, AWAVE, EUCLEN, IN,IQR, LEAST, MAD, MAXABS, MEAN, MEDIAN, MIDRANGE, RANGE, SPACING, STD, SUM, UST*/ var Marital_status;  run; ... View more

Hi, i need help with a technique for imputing numeric variables weight and height, I need to use the data for modelling is SAS Base(logistic regression)....see below table for my missing data   Variable Label N N Miss SUM_INSURED SUM_INSURED 23310 0 Monthly_income SALARY 23310 0 AGE_AT_INCEPT AGE_AT_INCEPT 23310 0 height_new   13349 9961 weight_new   19484 3826 ... View more

Hi, I need help with transposing the below data..please note that each policy_id contains 5 rows.. i need to transpose the data in such a way that i remain with 1 policy_id and 5 columns corresponding to the policy_id     data have; input policy_id question & $60. answer & $60.; cards; 1   alcohol         no                                    1 existing_cover no 1 height 1.2 1 lead_type out 1 weight 52 2  alcohol          no                                2 existing_cover yes 2 height 1.4 2 lead_type in 2 weight 55 3  alcohol          yes                                 3 existing_cover yes 3 height 1.6 3 lead_type in 3 weight 60 ;   Data Want policy_id    alcohol   existing_cover   height   lead_type   weight 1               yes            no                    1.2        out               52 2              no               yes                  1.4        in                 55 3              yes             yes                   1.6       in                 60   ... View more