Hi All,   I'm trying to create a stacked bar graph by day for 3 variables. My code to create the data is:   Data work.aht_changesCalcs; Set work.aht_changesAll; Keep EVENT_DT AHT ATT AHold ACW; ATT = TALK_TIME / TOTAL_CALLS; AHold = HOLD_TIME / TOTAL_CALLS; ACW = WORK_TIME / TOTAL_CALLS; AHT = (TALK_TIME + WORK_TIME + HOLD_TIME + EXTENDED_WORK_TIME) / TOTAL_CALLS; Format AHT ATT AHold ACW mmss.; Run;   and the output looks like this this   EVENT_DT          ATT  AHold  ACW   AHT 2017-10-16         6:54   1:23     1:55   10:11 2017-10-17         7:00   1:25     1:56   10:21 2017-10-18         7:06   1:21     1:55    10:22 2017-10-19        7:03    1:24      1:59   10:27 2017-10-20       7:11     1:26      1:59   10:36 2017-10-23       7:07     1:22      1:59   10:28 2017-10-24       7:03     1:22      1:56   10:22 2017-10-25      7:09      1:25      1:59   10:32 2017-10-26      7:07      1:21      1:54   10:23   The code I have to create the graph is only adding one variable at this stage (not sure how to add the others)   I need to have ATT, Ahold and ACW in the stacked graph.   Proc GCHART data=work.aht_changescalcs; VBAR EVENT_DT / Freq=ATT; Run; This code is adding additional multiple dates into the graph as seen in the output. How do I remove the additional dates and add the other variables into the bar?   I would like the final output to look like the below     All help appreciated.   Cheers Dean ... View more

Hi All,   I am currently working on time based metrics which give me results of over 24 hours and I want to show the result in HH:MM:SS.   EVENT_MEASURE_VAL is currently in seconds and I convert it by using the format  TIME. which gives me HH:MM . How can I format it to show HH:MM:SS   Proc Summary data=work.NotReady; By WEEK_END_DT; VAR EVENT_MEASURE_VAL event_cnt; Output out=work.notreadyROllUp (DROP=_FREQ_ _TYPE_) SUM=; RUN; Data work.notreadyrollupHH; Set work.notreadyrollup; Format event_measure_val time.; RUN; Current output WEEK_END_DT               EVENT_MEASURE_VAL            event_cnt 2017-04-02                                    368100                              651 2017-04-09                                 38908198                        29673 2017-04-16                                38843039                         23754 2017-04-23                                31642259                         20220 2017-04-30                                 29456216                     19358 2017-05-07                              8114040                          14610 2017-05-14                            7851055                            14183   Required Output   WEEK_END_DT     EVENT_MEASURE_VAL       event_cnt 2017-04-02             102:15:00                                    651 2017-04-09            10807:49:38                                29673 2017-04-16            10789:43:39                               23754 2017-04-23            8789:30:59                                20220     Regards   Dean ... View more

Hi All,   I have seen posts on this however I can't seem to work my head around it.   I have a 'list' of 11,152 logons (this number can change) which I use a the proc SQL to create.   proc sql; select quote (trim(Employee_ID)) into :Name_List separated by " " from work.janunique; quit; and it returns the error; ERROR: The length of the value of the macro variable NAME_LIST (65540) exceeds the maximum length (65534). The value has been        truncated to 65534 characters.   I use the list in the following where statement   Data work.Jan_Unallocated; Set Data.Employee_Telephony; Keep EVENT_DT DIVISION_NM BRANCH_NM PROGRAMME_NM_CT CENTRE_TYPE LOGON_ID EMPLOYEE_NAME TOTAL_CALLS WORK_TIME; Where Event_DT between '01Jan2017.'d and '31Jan2017.'d and Logon_ID in (&name_list); Run; Is there a way I can get around this error or change the Data step to allow the list to be used.   Thanks in advance.   Cheers   Dean         ... View more

Hi All,   At times I have large lists that I need to included in a Where statement (up too 387).   Is there a way I can create a list and reference that in the Where statement instead of having the individual code included in the statement?   In the example below remove all the AAA_ and reference a list that contains all of these.   Proc Sort data=Data.preagent out=Work.TrainingOverlay (Keep= week_end_dt CLUSTER Queue_CD Calls_Entered_cnt CALLS_ANSWERED_CNT); BY week_end_dt CLUSTER Queue_CD; Where week_end_dt >= '01Jul2016.'d and Queue_CD in ( 'AAA_ABR' 'AAA_ABS' 'AAA_ABS' 'AAA_ACD' 'AAA_ACE' 'AAA_ACR' 'AAA_ACY' 'AAA_ADV' 'AAA_AEC' 'AAA_AEI' 'AAA_AES' 'AAA_AIN' 'AAA_AIP' 'AAA_ALD' 'AAA_ALE' 'AAA_ALN' 'AAA_ALR' 'AAA_ALY' 'AAA_APR' 'AAA_ARA' 'AAA_ASR' 'AAA_BOS' 'AAA_BRA' 'AAA_BVL' 'AAA_BVL' 'AAA_CAN' 'AAA_CCB' 'AAA_CCP' 'AAA_CDT' 'AAA_CHD' 'AAA_CHK' 'AAA_CHS' 'AAA_CHY' 'AAA_CLH' 'AAA_CMC' ); run; Cheers   Dean ... View more

Hi All,   I need to create (or change) the 'event_dt' variable to match the relevant Australian Financial year quarters by several years; qtr 1 = Jul - Sep Qtr 2 = Oct - Dec Qtr 3 = Jan - Mar Qtr 4 = Apr - Jun     I have tried several methods however the results still returns a date value which then doesn't allow me to Summarize by the quarter/year.   Hope this makes sense.   Regrads   Dean ... View more

Hi All,   I have a proc means that creates multiple tables. I use ODS Excel to export it to excel. When it exports it creates a new tab for each table and I would like all the tables to appear on one worksheet.   Or ultimately If I can actually have all the data appear in one table.     Proc means data=work.acw_abs_baseline median Mean q1 q3 stddev; By Cluster Queue_cd; VAR AWT; Format AWT Comma9.0; Run; Current ouput   Cluster=ABS Queue Code=ABSa           The MEANS Procedure           Analysis Variable : AWT Median Mean Lower Quartile Upper Quartile Std Dev 107.3750000 138.5862480 58.7692308 174.2857143 142.0509725     Like the Output to look like this?                 Analysis Variable : AWT Cluster  Code Median Mean Lower Quartile Upper Quartile Std Dev ABS  ABSa 107.3750000 138.5862480 58.7692308 174.2857143 142.0509725 ABS  ABSb 67.0000000 121.4754246 17.6666667 143.0000000 275.3427533 DSC DSCa 251.0000000 327.7871022 134.0000000 421.5000000 329.8855516 DSC DSCb 226.3333333 288.4081027 114.0000000 387.0000000 278.9890103   Cheers   Dean       ... View more

Hi All,   I do reports that use the previous Sunday as the end date. I can calculate the Sunday based on the data _null_ step, but how do I now use that in the Where Week_end_dt =  'Sunday.'d;     data _null_; ref=today(); sunday = intnx('week1.2',ref,-1,'End'); format _all_ Date10.; put Sunday; run; Data work.TT_Weekly_report; Set Data.Employee; Keep Week_end_dt EVENT_DT Cluster Queue_CD TOTAL_CALLS TALK_TIME MBL; Where Week_end_dt = 'Sunday.'d; RUN;   Cheers   Dean     ... View more

Hi All,   I have multiple Proc Tabulates that I export out to excel workbook and I need to be able to five each worksheet a meaningful name.   I have used the ODS EXCEL option of sheet_name that names the first sheet to 'Entered' - how do I now assign names to the other worksheets?   ods excel file="/sasdata/OTH_Baselining.xlsx" options(Embedded_Titles='yes' Embedded_footnotes='YES' sheet_name='Entered'); ods escapechar="^"; Title1 font=Arial BOLD "Other Business Line Baseline"; Title2 font=Arial BOLD "01January 2017 to 20 August 2017"; Proc Tabulate data=work.Other_Baseline_SUM format=comma9.0 out=work.Other_Baseline_2; */ where Event_DT >= '01Jul2016'd; class Queue_type CLUSTER SDOCLUSTERPBS QUEUE_CD; VAR CALLS_Entered_CNT; Table Queue_type = "" * Cluster = "" * SDOCLUSTERPBS = "" * queue_cd ,CALLS_Entered_CNT="" * sum / box= "Entered Calls" ; run; Proc Tabulate data=work.Other_Baseline_SUM format=comma9.0 out=work.Other_Baseline_2; */ where Event_DT >= '01Jul2016'd; class Queue_type CLUSTER SDOCLUSTERPBS QUEUE_CD; VAR CALLS_Answered_CNT; Table Queue_type = "" * Cluster = "" * SDOCLUSTERPBS = "" * queue_cd ,CALLS_Answered_CNT="" * sum / box= "Entered Calls" ; run; Title1; title2; ODS EXcel close; Regards   Dean ... View more