Yes! I always searched for a vbar Option... But a proc freq before the proc gchart is best 🙂 Thanx for your help data_null_. ... View more

Great! Many thanx for your help. ... View more

I don't know annotate yet. But it seems worth learning.What you gave me as an example is exactly what I need. I guess I can use the html= option as addition to the above example? Because my customer wants to be able to click on the bar and the xaxis value (and also in a subgrouped bar chart by the way where clicking on a subgroup versus clicking on the value of the x axis makes sense in that I give a different target site depending on whether the user clicks on the subgroup or the xaxis value). ... View more

proc gchart data=sashelp.cars (where=(make in ("Audi","BMW")));      vbar make / freq = enginesize                     group = type                     subgroup = cylinders                     type=percent                     g100 /* effect: one group=100% , but I need one bar=100% */                     ; run; quit; ... View more

I tried your code above with activex and the drill down opens a new window 😞 I don't understand why different devices don't offer all functionality Why I didn't switch to png is because I always get the following error message with device=png: ERROR: Insufficient authorization to access /saspath/on/unix/server/gplot.png I use the following code: ods _all_ close; ods html file=_WEBOUT(no_top_matter no_bottom_matter) encoding="utf-8"; goptions reset=all device=png; <your code from above with the target=_self > ods _all_ close; ... View more

I tried it and the variable my_html looks in an example like this: target="_self" href="/SASStoredProcess/do?_program=%2FStored+Processes%2FprojectA%2Fmy_stp&year=2012" Unfortunately a new window opens at drill down. I use goptions device=activex. Is that a problem? ... View more

Hi there! I tried it with the subgrouped vbar and it works! options noquotelenmax; data work.mydata;      set report.mybigdata;      length drill_url $400.;      where ....;      drill_url = cats('/SASStoredProcess/do?_program=%2FStored+Processes%2FprojectA%2Fmy_stp&year=',year,'&country=',country,'&carmodel=',carmodel); run; proc gchart data=work.mydata;      vbar year / sumvar = mysum                      group = country                      subgroup = carmodel                      discrete                      html = drill_url; run; quit; Remains the question how to open the target STP in the same window. And another question: I need to have a drilldown by clicking on the group name on the x-axis. E.g. the group variable in country and I have Germany and USA on the x-axis. I'd like to be able to click on the word "Germany" and thus make a drill down. Is that possible? and how? Best wishes Eva ... View more

Dear Robert, I worked with what you suggested. Yes, I have an STP running which displays my graph. And it is also able to display a table depending on the parameters I send to the STP. I used the html Option on a simple gchart (not stacked): options noquotelenmax; /* to erase the warning when the drill string gets too long */ data work.mydata;      set report.mybigdata;      length drill_url $400.;      where .....;      drill_url = cats('/SASStoredProcess/do?_program=%2FStored+Processes%2FprojectA%2Fmy_stp&year=',year,'&country=',country); run; proc gchart data=mydata;      vbar year / sumvar=mysum                      group=country                      discrete                      html=drill_url; run; quit; When I click on a bar a new window openes and correctly displays what I want to see. The parameters are sent and used by the target STP. Is it possible to have the drill down open in the same window instead of in a pop-up window? And secondly: can I use the same code with subgroup in the proc gchart and be able to click on one segment of the bar? Best wishes Eva ... View more

Unfortunately not supported by activex. Like axis split='...' is not 😞 ... View more

I formatted the variable I user for the pointlabel now in commax10.2 Unfortunately then the values on the y-axis are also in this format. Can I use a different format for the values on an axis? ... View more

Dear Robert, thanx. I would never have googled for "pointlabel" 🙂 It works. And foundit now in the sas help. Best wishes Eva ... View more