Hi Robert! First of all, thanks for your suggestions. Now, I want to set up black coutline for bars. This is my code. %let date2=31JAN2012:0:0:0; %let date1=31DEC2011:0:0:0; %let Bilan_Ukupnof_2=33488; %let Bilan_Ukupnof_1=33474; %let VANBilan_HRK_Ukupnof_2=4222; %let VANBilan_HRK_Ukupnof_1=3887; %let Izloz_RNH_f_2=4590; %let Izloz_RNH_f_1=4668; %let Izloz_DRT_f_2=548; %let Izloz_DRT_f_1=504; %let Izloz_FSA_f_2=4260; %let Izloz_FSA_f_1=4266; %let Izloz_Others_f_2=4347; %let Izloz_Others_f_1=4343; %let TOTAL_GE_f_2=47195; %let TOTAL_GE_f_1=46896; %put &Bilan_Ukupnof_2; PROC SQL; CREATE TABLE waterfall (date num informat=datetime22.3 format=datetime22., flag char(20), Segment char(6), value num format=commax20., GROUPVAR char(1) ) ; INSERT INTO waterfall VALUES("'&date2'"dt,"previous_ month","Clear",0,"1") VALUES("'&date2'"dt,"previous_month","CRE",%sysevalf (&Bilan_Ukupnof_2),"1") VALUES("'&date2'"dt,"previous_month","KIP",0,"1") VALUES("'&date2'"dt,"previous_month","RNH",0,"1") VALUES("'&date2'"dt,"previous_month","DRT",0,"1") VALUES("'&date2'"dt,"previous_month","Others",0,"1") VALUES("'&date2'"dt,"previous_month","TOTAL",0,"1") VALUES("'&date2'"dt,"previous_month","Clear",%sysevalf (&Bilan_Ukupnof_2),"2") VALUES("'&date2'"dt,"previous_month","CRE",0,"2") VALUES("'&date2'"dt,"previous_month","KIP",%sysevalf (&VANBilan_HRK_Ukupnof_2),"2") VALUES("'&date2'"dt,"previous_month","RNH",0,"2") VALUES("'&date2'"dt,"previous_month","DRT",0,"2") VALUES("'&date2'"dt,"previous_month","Others",0,"2") VALUES("'&date2'"dt,"previous_month","TOTAL",0,"2") VALUES("'&date2'"dt,"previous_month","Clear",%sysevalf (&Bilan_Ukupnof_2+&VANBilan_HRK_Ukupnof_2),"3") VALUES("'&date2'"dt,"previous_month","CRE",0,"3") VALUES("'&date2'"dt,"previous_month","KIP",0,"3") VALUES("'&date2'"dt,"previous_month","RNH",&Izloz_RNH_f_2,"3") VALUES("'&date2'"dt,"previous_month","DRT",0,"3") VALUES("'&date2'"dt,"previous_month","Others",0,"3") VALUES("'&date2'"dt,"previous_month","TOTAL",0,"3") VALUES("'&date2'"dt,"previous_month","Clear",%sysevalf (&Bilan_Ukupnof_2+&VANBilan_HRK_Ukupnof_2+&Izloz_RNH_f_2),"4") VALUES("'&date2'"dt,"previous_month","CRE",0,"4") VALUES("'&date2'"dt,"previous_month","KIP",0,"4") VALUES("'&date2'"dt,"previous_month","RNH",0,"4") VALUES("'&date2'"dt,"previous_month","DRT",&Izloz_DRT_f_2,"4") VALUES("'&date2'"dt,"previous_month","Others",0,"4") VALUES("'&date2'"dt,"previous_month","TOTAL",0,"4") VALUES("'&date2'"dt,"previous_month","Clear",%sysevalf (&Bilan_Ukupnof_2+&VANBilan_HRK_Ukupnof_2+&Izloz_RNH_f_2+&Izloz_DRT_f_2), "5") VALUES("'&date2'"dt,"previous_month","CRE",0,"5") VALUES("'&date2'"dt,"previous_month","KIP",0,"5") VALUES("'&date2'"dt,"previous_month","RNH",0,"5") VALUES("'&date2'"dt,"previous_month","DRT",0,"5") VALUES("'&date2'"dt,"previous_month","Others",%sysevalf (&Izloz_Others_f_2),"5") VALUES("'&date2'"dt,"previous_month","TOTAL",0,"5") VALUES("'&date2'"dt,"previous_month","Clear",0,"6") VALUES("'&date2'"dt,"previous_month","CRE",0,"6") VALUES("'&date2'"dt,"previous_month","KIP",0,"6") VALUES("'&date2'"dt,"previous_month","RNH",0,"6") VALUES("'&date2'"dt,"previous_month","DRT",0,"6") VALUES("'&date2'"dt,"previous_month","Others",0,"6") VALUES("'&date2'"dt,"previous_month","TOTAL",%sysevalf (&TOTAL_GE_f_2),"6") VALUES("'&date1'"dt,"current_month","Clear",0,"1") VALUES("'&date1'"dt,"current_month","CRE",%sysevalf (&Bilan_Ukupnof_1),"1") VALUES("'&date1'"dt,"current_month","KIP",0,"1") VALUES("'&date1'"dt,"current_month","RNH",0,"1") VALUES("'&date1'"dt,"current_month","DRT",0,"1") VALUES("'&date1'"dt,"current_month","Others",0,"1") VALUES("'&date1'"dt,"current_month","TOTAL",0,"1") VALUES("'&date1'"dt,"current_month","Clear",%sysevalf (&Bilan_Ukupnof_1),"2") VALUES("'&date1'"dt,"current_month","CRE",0,"2") VALUES("'&date1'"dt,"current_month","KIP",%sysevalf (&VANBilan_HRK_Ukupnof_1),"2") VALUES("'&date1'"dt,"current_month","RNH",0,"2") VALUES("'&date1'"dt,"current_month","DRT",0,"2") VALUES("'&date1'"dt,"current_month","Others",0,"2") VALUES("'&date1'"dt,"current_month","TOTAL",0,"2") VALUES("'&date1'"dt,"current_month","Clear",%sysevalf (&Bilan_Ukupnof_2+&VANBilan_HRK_Ukupnof_1),"3") VALUES("'&date1'"dt,"current_month","CRE",0,"3") VALUES("'&date1'"dt,"current_month","KIP",0,"3") VALUES("'&date1'"dt,"current_month","RNH",&Izloz_RNH_f_1,"3") VALUES("'&date1'"dt,"current_month","DRT",0,"3") VALUES("'&date1'"dt,"current_month","Others",0,"3") VALUES("'&date1'"dt,"current_month","TOTAL",0,"3") VALUES("'&date1'"dt,"current_month","Clear",%sysevalf (&Bilan_Ukupnof_1+&VANBilan_HRK_Ukupnof_1+&Izloz_RNH_f_1),"4") VALUES("'&date1'"dt,"current_month","CRE",0,"4") VALUES("'&date1'"dt,"current_month","KIP",0,"4") VALUES("'&date1'"dt,"current_month","RNH",0,"4") VALUES("'&date1'"dt,"current_month","DRT",&Izloz_DRT_f_1,"4") VALUES("'&date1'"dt,"current_month","Others",0,"4") VALUES("'&date1'"dt,"current_month","TOTAL",0,"4") VALUES("'&date1'"dt,"current_month","Clear",%sysevalf (&Bilan_Ukupnof_1+&VANBilan_HRK_Ukupnof_1+&Izloz_RNH_f_1+&Izloz_DRT_f_1), "5") VALUES("'&date1'"dt,"current_month","CRE",0,"5") VALUES("'&date1'"dt,"current_month","KIP",0,"5") VALUES("'&date1'"dt,"current_month","RNH",0,"5") VALUES("'&date1'"dt,"current_month","DRT",0,"5") VALUES("'&date1'"dt,"current_month","Others",%sysevalf (&Izloz_Others_f_1),"5") VALUES("'&date1'"dt,"current_month","TOTAL",0,"5") VALUES("'&date1'"dt,"current_month","Clear",0,"6") VALUES("'&date1'"dt,"current_month","CRE",0,"6") VALUES("'&date1'"dt,"current_month","KIP",0,"6") VALUES("'&date1'"dt,"current_month","RNH",0,"6") VALUES("'&date1'"dt,"current_month","DRT",0,"6") VALUES("'&date1'"dt,"current_month","Others",0,"6") VALUES("'&date1'"dt,"current_month","TOTAL",%sysevalf (&TOTAL_GE_f_1),"6") ; SELECT * FROM waterfall; QUIT; data waterfall; set waterfall; new=trim(flag)||groupvar; run; %_sas_pushchartsize(1000,800); pattern1 v=s c=white; pattern2 v=s c=mob/*CX003366*/ ; pattern3 v=s c=vibg/*CX90B0D9*/; pattern4 v=s c=darker_blue/*CX325682*/; pattern5 v=s c=CX90B0D9/*CXB22222*/; pattern6 v=s c=orange/*CX325682*/; pattern7 v=s c=FireBrick/*CXB22222*/; /* Define axis characteristics */ axis1 minor=none; /* Add the title */ title 'Campaign Contributions in 2007'; goptions htext=12pt ctext=white; /*PATTERN1 COLOR=CX003366; PATTERN2 COLOR=CX90B0D9;*/ Axis1 order=(25000 to 50000 by 5000 ) STYLE=1 WIDTH=1 color=black MINOR=NONE LABEL=(angle=90 f="Arial" h=12pt "mio HRK") VALUE=(F="arial" HEIGHT= 5pt) ; Axis2 LABEL=none VALUE=(f='Arial' HEIGHT=12pt "12/11" "01/12" "12/11" "01/12" "12/11" "01/12" "12/11" "01/12" "12/11" "01/12" "12/11" "01/12") offset=(5,5) color=black; Axis3 LABEL=none VALUE=(f='Arial' HEIGHT=12pt "CRE" "KIP" "RNH" "DRT" "Others" "Total") color=black; Legend1 NOFRAME CBORDER=WHITE CFRAME=WHITE POSITION = (TOP LEFT INSIDE) LABEL=none VALUE=(f='Arial' HEIGHT=12pt c=black '' 'CRE' 'DRT' 'KIP' 'Others' 'RNH' 'Total' ) offset=(0,0) shape=bar(3,1) MODE=SHARE across=7; TITLE; TITLE1; TITLE2 h=7.5pt color="darker_blue" move=(67,34.50) JUSTIFY=CENTER font =arial "Naslov"; FOOTNOTE; FOOTNOTE1; PROC GCHART DATA=WORK.waterfall ; VBAR flag /inside=sum SUMVAR=value GROUP=groupvar SUBGROUP=segment /*midpoints="CRE" "KIP" "RNH" "DRT" "Others" "Total"*/ CLIPREF gspace=1.5 space=0 WIDTH=8.5 coutline=white legend=legend1 RAXIS=AXIS1 MAXIS=AXIS2 GAXIS=AXIS3 des="" name="wfall"; format value commax7. ; RUN; QUIT; TITLE; FOOTNOTE; TITLE; FOOTNOTE; GOPTIONS RESET = SYMBOL; %_sas_popchartsize;
... View more
