Hi All,   I use the following code to select the previous days date.     %let DateVAR = %sysfunc(intnx(day,%sysfunc(today()),-1),yymmddn8.); I need to now select the previous days date for a report except when it is run on a Monday I need it to return the Fridays date.   So if the report is run on Monday 9 July 2018 the date returned will be 6 July 2018.   How do I change this code to do this or is there different code I will need to use.   Cheers   Dean ... View more

Hi All,   I am trying to work out how to change the name in a SGPLOT legend. I'm using 1,2 and 3 to order the grouping in the bar chart 1 = ATT 2= AHold  3= AWT   How do I now give the legend 'meaningful' names.   I'm using SAS 9.4   My code looks similar to this       Data test; Input date $ count average type; Datalines; 43252 2124 515 1 43252 2124 162 2 43252 2124 166 3 43255 2984 491 1 43255 2984 156 2 43255 2984 171 3 43256 2713 518 1 43256 2713 153 2 43256 2713 161 3 43257 2540 509 1 43257 2540 156 2 43257 2540 157 3 ; RUN; Proc SGPLOT data=test; HBAR date / Response=average Group=type datalabel seglabel; xaxis display=(noline noticks) grid values=(0 to 1200 by 150) offsetmin=0; RUN; and my output looks like this       any help appreciated   Cheers   Dean     ... View more

Hi All   I'm using the following SGPLOT to produce a bar chart - however I would like to change the colour of the fill attributes based on the date (indicated by P - I can't add dates successfully to test data 😞 ) to identify when a change occurred to the business rules.     Data test; Input Date $ Result; Datalines; A 117 B 76 C 60 D 52 E 75 F 63 G 70 H 73 I 58 J 52 K 32 L 120 M 73 N 62 O 71 P 108 Q 85 ; Run; Proc SGPLOT data=test noborder; Title "Results"; VBAR Date / RESPONSE=Result FILLATTRS=(Color=BIBG) ; yaxis display=(noline noticks) ; RUN; The output result is in the Current Result graph and I would like it to look like Required Results graph.     How do I change my code to show different colours? Any help appreciated.   Cheers   Dean   ... View more

Hi All,   I am using the IF statements to allocate numbers to variables, then I need to create a new variable that shows the total of these. But when I use I create the new variable in another data step it doesn't add them together.     IF Active_INAa > ' ' THEN INAa = 1; IF Active_INDa > ' ' THEN INDa = 2; IF Active_IRSa > ' ' THEN IRSa = 4; IF Active_INIa > ' ' THEN INIa = 8;         Data work.Test2; SET work.Test1; Total = INAa + INDa + IRSa + INIa; RUN;   The Total column is created but is blank.   What am I missing here? Any help appreciated.   Cheers   Dean           ... View more

Hi All,   I have data that I need to create a new variable based on the 4 variables Active1 - Active4).   The observations in the variables can be Blank YES NO I need to be able to create a new variable called 'Active' that says YES if any one of the variables has YES and NO if they are a mixture of BLANK or NO.   Apologies I can't get the data into a test Agent EMPLOYEE_NAME Active1 Active2 Active3 Active4 Active AAA A YES YES Yes YES YES BBB B YES NO NO NO YES CCC A Yes Yes NO NO YES DDD B Yes NO      YES EEE A YES YES     YES FFF B YES NO   YES YES GGG A         NO HHH B   YES     YES III A NO   NO   NO This is some code I have used when only two variables exist but hoping there is a better way to code this.   IF Active1 = " " and Active2= " " Then SPTN = 'NO'; ELSE IF Active1 = "NO" and Active2= "NO" Then SPTN = 'NO'; ELSE IF Active1 = "NO" and Active2= "" Then SPTN = 'NO'; ELSE IF Active1 = " " and Active2= "NO" Then SPTN = 'NO'; ELSE IF Active1 = "YES" and Active2= " " Then SPTN = 'YES'; ELSE IF Active1 = " " and Active2= "YES" Then SPTN = 'YES'; ELSE IF Active1 = "YES" and Active2= "NO" Then SPTN = 'YES'; ELSE IF Active1 = "YES" and Active2= "YES" Then SPTN = 'YES'; Any help appreciated   Cheers   Dean   Agent EMPLOYEE_NAME Active1 Active2 Active3   AAA A YES YES Yes YES BBB B YES NO NO NO CCC A Yes Yes NO NO DDD B Yes NO      EEE A YES YES     FFF B YES NO   YES GGG A         HHH B   YES     III A         ... View more

Hi All,   I would like to set the size of my graphs in ODS Excel.   The current out put sizes the graphs to 9.87cm x 14.99cm (3.88inch x 5.9inch) I would like to set the graphs to 17cm x 26cm (6.6inch x 10.2inch)   I have used  both of the below to no avail. ods graphics on / width=8in  height=4in; goptions vsize=10cm hsize=20cm   %let DateVAR =  %sysfunc(intnx(day,%sysfunc(today()),-1),yymmddn8.); ods excel file="/test/Testa&DateVAR..XLSX"; ODS EXCEL OPTIONS (EMBEDDED_Titles="YES" sheet_Interval="NONE"); ODS Excel Options (embedded_Titles="YES") NOGTITLE NOGFOOTNOTE; ods graphics on / width=8in  height=4in; ods excel options(sheet_name='Overall'); Proc SGPLOT data=test;  Series x=Date y=successful / lineattrs=(color=blue thickness=3) Legendlabel='Successful';  Series x=Date y=Unsuccessful / lineattrs=(color=RED  thickness=3) Legendlabel='UnSuccessful';  yaxis display=(noline noticks) grid values=(0 to 325000 by 25000) offsetmin=0 label='Count';  Format Successful UnSuccessful comma9.;  RUN; Any help in resizing the graphs is appreciated.   Cheers   Dean ... View more

Hi All,   I have created a combo graph that has two bars and three lines, however the second bar sits behind the first one.   How do I get them to sit side by side to each other?     Data test; Input WEEK_END_DT $ TransA TransB PCTA PCTB PCTC; Datalines; A 5063 3487 0.170074793 0.133479212 0.282554088 B 8094 9028 0.146952298 0.097315235 0.270777721 C 9512 10226 0.144833102 0.095077215 0.282205541 D 11004 11326 0.163079597 0.107464086 0.328004634 E 10591 10351 0.171097567 0.112158341 0.370088312 F 14045 11853 0.166789031 0.113834383 0.371648951 G 14643 10257 0.158547224 0.113666708 0.363375492 H 15739 7427 0.157418355 0.124353109 0.36062151 I 16056 6942 0.156742205 0.126345609 0.353372359 J 15074 6714 0.145029987 0.115199731 0.346439628 K 15014 4723 0.136847725 0.11575052 0.325365114 L 13918 5926 0.142005567 0.113826324 0.339268335 M 14402 4526 0.132393263 0.111817638 0.319429741 N 12071 2903 0.129682074 0.113615828 0.314756587 RUN; Proc SGPlot data=Test; Title "Overal Transfers"; VBAR WEEK_END_DT / Response=TransA Fillattrs=(Color=BIBG ) groupdisplay=stack Legendlabel='IIE Transfers'; VBAR WEEK_END_DT / Response=TransB Fillattrs=(Color=VIPK )groupdisplay=stack Legendlabel='NON IIE Transfers';; VLine WEEK_END_DT / response=PCTA y2axis lineattrs=(color=darksalmon thickness=5) Legendlabel='Total Transfer %'; VLine WEEK_END_DT / response=PCTB y2axis lineattrs=(color=Blue thickness=5) Legendlabel='NON IIETransfer %'; VLine WEEK_END_DT / response=PCTC y2axis lineattrs=(color=Green thickness=5) Legendlabel='IIE Transfer %'; Yaxis values=(0 to 20000 by 2000); y2axis values=(0 to .50 by .02) Label='Trans %'; format PCTA PCTB PCTC Percent.; Run; What I get                                         What I would like.     Any help appreciated.   Cheers   Dean     ... View more