Hi Robert Thank you very much, that is exactly  what I'm looking for. Thank you Bob ... View more

Hi Robert My apology for previous “explanations”  I will make it simple. data test; format percent percentn10.2; input week percent sum_week target; datalines; 18 0.83 8953 8400 19 0.85 6970 6720 20 0.87 9766 8400 21 0.88 9493 8400 22 0.91 10104 8400 ; run; Blue – target Red – sum_week Purple – percent Horizontal - week Thank you very much Bob ... View more

Hi Robert Thank you very much, working like a charm. One more question What in case that each week has different target (each week two connected bars in different colors )  and target value is in input test table? Thank you again Bob ... View more

Hi Robert Thank you for your help. Can you help me with one more thing about this graph. I want to add new bar for every week. Target bar with fixed value 5000. How to implement this into graph? Thank you in advance Bob ... View more

Hi Robert Thank you very much. This is great and exactly what I'm looking for. Thank you again Bob ... View more

Hi Robert Than you very much. Working like a charm but i need a little more help with these.  My data: data test;                                                                                                                          length week $ 2 operation $ 2 sum_week $ 5;     format percent percentn10.2 ;    input week  operation percent sum_week;                                                                                                     datalines; 18 a 0.21 5842 18 b 0.34 5842    18 c 0.13 5842    18 d 0.15 5842    18 e 0.02 5842    18 f 0.11 5842    19 a 0.11 8501 19 b 0.14 8501    19 c 0.23 8501    19 d 0.25 8501    19 e 0.32 8501    19 f 0.21 8501 20 a 0.21 7007 20 b 0.34 7007    20 c 0.13 7007    20 d 0.15 7007    20 e 0.02 7007    20 f 0.11 7007   ; run; I need to export graph same as in previous attachment: On left side percent, on vertical bar sum_week,  right side sum_week, ,the five variables(a,b,c,d,e,f) should be percent for single operations  and also legend for each operations color + operations name. Thank you again . Bob ... View more

Hi Cynthia, PG Thank you very much. Solution is perfect. It is time for me to learn proc report. Thank you again. Bob ... View more

Thank you very much PG Stats. There is a syntax error  and i think the problem is in my version of SAS 9.1 46   /* Define a color format that interprets the decimals as the target */ 47   proc fcmp outlib=sasuser.fcmp.format; 48        function bTarget(x) $16; 49 50             if missing(x) then return ("verylightyellow");                                           ------------------                                           22               200 51             else if int(x) < round(10000*(x-int(x))) then return ("verylightred");                                                                      ---------------                                                                      22            200 52             else return ("white");                             --------                             22     200 ERROR 22-322: Syntax error, expecting one of the following: a name, a numeric constant,               a datetime constant, a missing value, (, +, -, IF. ERROR 200-322: The symbol is not recognized and will be ignored. 53        endsub; 54   run; and proc format ; 59   value col 60   other  =  [bTarget()];                        -                        22                         -                         200 ERROR 22-322: Syntax error, expecting one of the following: a quoted string, a numeric constant,               a datetime constant, a missing value, ;, LOW, OTHER. ERROR 200-322: The symbol is not recognized and will be ignored. Thak you again. Bob ... View more

Thank you very much PG Stats and Qli. Working like a charm. Is it possible to make the comparison to a moving target? Bob ... View more

Ksharp Thank You According SAS9.1 documentation It is a time for new version of SAS Bob ... View more

1. My SAS is PC version. SAS 9.1.3. Service Pack 4 for XP_PRO platform. 2. Yes, save as *.xps and table is in file. 3. Also found one error in error log. "printerpath = ERROR 3-12: Invalid option value." Bob ... View more

Hi Ksharp Thank you for quick respond. 1. When I run this SAS first ofer me window "save as *.xps" I wan't just to export to image file. 2. When I cancel "save as ..." window SAS finalze export to png but no image in it, just empty png file. 3. printerpath = ERROR 3-12: Invalid option value. Thank you again. Bob ... View more