About DME790

DME790 · ‎01-04-2018

Hi All, I have seen this written about but can't get it to work. The Microsoft SAS Add-In has been disabled at work so I can't use that. My spreadsheet is saved to the server /sasdata/Report/ExpansionReportDRAFTv01.xlsx. The named range is called SASData and is in the tab called DATA in the spreadsheet. I get the following error when I run the LIBNAME statement: ERROR: The EXCEL engine cannot be found. ERROR: Error in the LIBNAME statement. And not sure if I have the correct code in the data step. Libname XL excel "/sasdata/Report/ExpansionReportDRAFTv01.xlsx"; Data XL.SASData; Set work.Succ_Answered_AHT_TransferMerge; RUN; Any help is appreciated. Cheers Dean

DME790 · ‎01-01-2018

Hi All, I need to calculate the percentage on multiple columns in a Proc Report. I'm using Compute Before however after the first compute I get the following error - ERROR: There are multiple COMPUTE statements for RBREAK BEFORE . My test data is data test; Input Centre $ A B C D E F Total_Calls; Datalines; ADL 3 279 646 . 276 120 1324 BAL . 1298 1775 . 200 859 4152 Bay . 928 . 4 . 12 944 Ben 546 . . 195 1 60 802 Bri . 342 736 . 69 429 1576 Bun . 966 2257 . 214 1199 4636 Cai 163 . 2 . . 631 796 Can 16 . 137 . . 91 244 Cen 450 2 774 400 . 396 2022 Cof 2465 1 2206 876 . 311 5859 ; Run; and the proc report code is Proc Report Data=Test; Column CENTRE A B C D E F Total_Calls APct BPct; Define Centre / DISPLAY; Define A / DISPLAY 'A' Analysis SUM f=comma9. Style(Column)=[cellwidth=1in]; Define B / DISPLAY 'B' Analysis SUM f=comma9. Style(Column)=[cellwidth=1in]; Define C / DISPLAY 'C' Analysis SUM f=comma9. Style(Column)=[cellwidth=1in]; Define D / DISPLAY 'D' Analysis SUM f=comma9. Style(Column)=[cellwidth=1in]; Define E / DISPLAY 'E' Analysis SUM f=comma9. Style(Column)=[cellwidth=1in]; Define F / DISPLAY 'F' Analysis SUM f=comma9. Style(Column)=[cellwidth=1in]; Define Total_calls / Display 'Total' Analysis SUM f=comma9. Style(Column)=[cellwidth=1in]; Compute Before; A_Total = A.SUM; Endcomp; Define APct / COMPUTED 'A Percent' f=Percent9.0 STYLE( column )={TAGATTR='format:0.00'}; Compute APct; APct = A.SUM / A_Total; ENDCOMP; Compute before; B_Total = B.SUM; Endcomp; Define BPct / COMPUTED 'B Percent' f=Percent9.0 STYLE( column )={TAGATTR='format:0.00'}; Compute BPct; BPct = B.SUM / B_Total; ENDCOMP; RBREAK AFTER / SUmmarize; Run; If I use the Compute after in the second and subsequent Compute statements it doesn't calculate the percentage. The output I want would look like Is Proc Report the best proc to use? ANy help appreciated. Cheers Dean

DME790 · ‎12-12-2017

Hi All, I need to calculate the percentage of each an observation within that variable. I have this cade at the moment data test; Input QUEUE_CD $ Bay Network; Datalines; ABS 1 22949 ACD 1 3767 ACE 2 967 ACR 18 20513 ADV 5 92382 ALD 1 1764 ALE 17 13243 ALY 2 5128 CCB 1 25006 CHK 3295 25129 ; Run; Proc Report data=test; Column queue_cd Bay Network BayPercent; Define Queue_CD / Display 'Queue'; Define Bay / Display 'Baylink' Analysis sum f=comma9.; Define Network / Display 'Network' Analysis sum f=comma9.0; Define BayPercent / Computed 'Bay Percent of Network' f=percent9.2; Compute BayPercent; BayPercent = Bay.sum / Network.sum; Endcomp; Rbreak after / summarize; RUN; which gives me the output of Need to add the Bay Percent into the Proc Report Any help appreciated. Cheers Dean

DME790 · ‎12-05-2017

Thanks @ballardw works a treat. Is there a way you can output SQL to a new data set name like output work.FootprintEMS; Cheers Dean

DME790 · ‎12-05-2017

Hi All, I need to count the number of unique LOGON_ID based on the FOOTPRINT. I'm not sure how to get the result I need. Sample data below Data test; Input FOOTPRINT $ EMPLOYMENT_TYPE $ LOGON_ID $ EMPLOYEE_NAME $ CLUSTER $ QUEUE_CD $ num1; datalines; Adelaide FT ADM Murdock EMS ALE 2 Adelaide FT ADM Murdock EMS EMS 16 Adelaide FT AGA Andrews FAP CSA 6 Adelaide FT AGA Andrews FAP F04a 4 Adelaide FT AGA Andrews FAP F07 38 Sydney FT AGB Bev FAP F13 3 Sydney FT AGB Bev FAP F20 2 Sydney FT AGB Bev FAP F21 6 Sydney FT AGC Charlie FAP F22 53 Sydney FT AGC Charlie FAP F24a 2 Sydney FT AGD David FAP F25 1 Sydney FT AGE Edward FAP F60a 8 ; Run; The result I'm looking from the example data is FOOTPRINT Unique_Count Adelaide 2 Sydney 4 Any help or advice appreciated Cheers Dean

DME790 · ‎12-04-2017

Hi @Ksharp Still working on this one. Seems in a proc tabulate there is no style to rotate the heading text. I can't seem to find anything within ods tagesets.msoffice2k_m that helps me either. Any other suggestions? Cheers Dean

DME790 · ‎11-23-2017

Thanks @stat_sas Is exactly what I was looking for. Cheers Dean

DME790 · ‎11-23-2017

Hi All, I'm trying to add a percentage from the 'total' in a proc report. I have read a couple of submissions but not making sense to me. My data looks like 9apologies if the test data doesn't work) data test; input ORIGIN_CD TARGET_CD SP04 SP05 SP06 Total; datalines; ABR A 14 12 6 32 ABR B 2 . 1 3 ABR C . 2 1 3 ABR D . 1 . 1 ABR E . . 1 1 ABR F . 1 . 1 ABR G 1 . 1 2 ABR H . 1 . 1 ABR I . . 4 4 ABR J 1 1 1 3 ABR K 1 1 . 2 ABR L . . 1 1 ABR M 1 3 9 13 ; Run; My code is Proc Report data=work.origindestbyqueuecalc; by origin_cd; Column ORIGIN_CD TARGET_CD SP04 SP05 SP06 Total ; define Origin_CD / Display 'Origin'; Define Target_CD / DISPLAY 'Destination'; Define SP04 / DISPLAY 'SP2018_04' analysis SUM f=comma9.; Define SP05 / DISPLAY 'SP2018_05' analysis SUM f=comma9.; Define SP06 / DISPLAY 'SP2018_06' analysis SUM f=comma9.; Define Total / DISPLAY 'Total' analysis sum; Rbreak after / summarize; RUN; which gives me the output of and I would like the output to look like the following Any help appreciated Cheers Dean

DME790 · ‎11-23-2017

Thanks @Reeza and @art297 for the response. I ended up going with SP = SUBSTR(TRIM(SETTLEMENT_PERIOD_NM),length(Trim(SETTLEMENT_PERIOD_NM))-1); Cheers Dean

DME790 · ‎11-23-2017

Hi All, I need to format text to a number - I'm trying to use Proc Format Proc Format lib=work; Value SPGroup SP2018-01 = '1' SP2018-02 = '2' SP2018-03 = '3' SP2018-04 = '4' SP2018-05 = '5' SP2018-06 = '6' SP2018-07 = '7' SP2018-08 = '8' SP2018-09 = '9' SP2018-10 = '10' SP2018-11 = '11' SP2018-12 = '12' SP2018-13 = '13' ; RUN; is it possible to use proc format in this instance or is there an easier way to just return the last two characters of the observation ie return 01 from SP2018-01. Any help is appreciated. Cheers Dean

DME790 · ‎11-09-2017

Hi All, I have a proc tabulate that has long names as the headers. I want to change the orientation of the words to be vertical in the header so the table fits to one page and is easier to read. Proc Tabulate data=work.warra_trans_vq format=comma.; Class origin_cd target_cd; VAR TRANSFER_CNT; Table Origin_CD = " " All = " " ,Target_CD = "Target" * transfer_cnt=" " /Box="Transfers" ; Keylabel SUM=" "; Run; Current output looks like this: Required output: Cheers Dean

DME790 · ‎10-31-2017

Hi @Damo, It is now showing the per values. Not sue what happened as I haven't changed any code - feel silly now. Thanks for all the support. Cheers Dean

DME790 · ‎10-30-2017

Hi @Damo, I can run Sample 55866 and it shows the segment results I have got seglabel in the code however it doesn't display the segment values in the bars. I am using 9.4 m2 proc sgplot data=work.AHT_OTH_PercCalc; vbar EVENT_DT / response=Per Group=Category stat=SUM datalabel seglabel ; YAXIS max=1 Label="Percentage" Values=(.1 to 1 by .05); run; It shows the datalabel at the top of the bars but not the segments. Cheers Dean

DME790 · ‎10-30-2017

All, I'm trying to add data labels into a stacked bar graph. Part of my data looks like this: Category Per EVENT_DT ATTPerc 67.16% 25/09/2017 AHoldPerc 12.29% 25/09/2017 ACWPerc 20.55% 25/09/2017 ATTPerc 68.25% 26/09/2017 AHoldPerc 12.18% 26/09/2017 ACWPerc 19.57% 26/09/2017 ATTPerc 68.11% 27/09/2017 AHoldPerc 12.57% 27/09/2017 ACWPerc 19.32% 27/09/2017 ATTPerc 67.87% 28/09/2017 AHoldPerc 11.28% 28/09/2017 ACWPerc 20.84% 28/09/2017 ATTPerc 69.01% 29/09/2017 AHoldPerc 12.09% 29/09/2017 ACWPerc 18.90% 29/09/2017 ATTPerc 67.98% 2/10/2017 AHoldPerc 11.91% 2/10/2017 ACWPerc 20.12% 2/10/2017 proc sgplot data=work.AHT_OTH_PercCalc; vbar EVENT_DT / response=Per Group=Category datalabel seglabel ; YAXIS max=1 Label="Percentage" Values=(.1 to 1 by .05); run; I have tried datalabel seglabel however only the datalabel is showing in the chart. How can I get the datalabels to show? All help appreciated. Cheers Dean

DME790 · ‎10-29-2017

Thanks Tom, When you see the code it looks so simple. Thankyou very much. Cheers Dean

Online Status	Offline
Date Last Visited	‎08-04-2020 01:23 AM

Proc Append Monthly Data

Re: help with Merge

help with Merge

Re: Import CSV or a SAS EG file into SAS VA

Import CSV or a SAS EG file into SAS VA

Re: remove duplicates based on variables

remove duplicates based on variables

Re: Replace data in a table

Replace data in a table

Re: include missing metrics

Re: count of repeat contacts fromk previous days

Re: ODS PDF graph layout

Re: SGPLOT - Attrmap and Proc Format not working together

Re: return yesterdays date except on a Monday return the Friday date

Re: Change the names in alegend in an SGPLOT

Re: change the Y axis interval and max number on a SGPLOT

change the Y axis interval and max number on a SGPLOT

Re: Using a Date_Range Prompt in a Data Step SAS EG7.1

Using a Date_Range Prompt in a Data Step SAS EG7.1

Re: Import CSV or a SAS EG file into SAS VA

Export results to a named range in excel

Multiple Compute Before in Proc Report

Proc Report percentgae of column based on column total

Re: Count unique observations

Count unique observations

Re: Orientation of the words in a Proc Tabulate Heading

Re: Adding a percentage to a PRoc Report

Adding a percentage to a PRoc Report

Re: Proc format text to a number

Proc format text to a number

Orientation of the words in a Proc Tabulate Heading

Re: Data label in a Stacked Bar Graph

Re: Data label in a Stacked Bar Graph

Data label in a Stacked Bar Graph

Re: Create a stacked bar graph