HI All, I have a horizontal bar chart that has very long data labels so that the chart itself is truncated. Is there a way to either wrap the text or expand the right side of the graph? I used proc sgplot because I want the groups to be stacked on top of one another, which I don't think is possible in proc gchart. Please see have.png for what the chart looks like and want.png as an example of how I'd like it to look. Thanks! Sarah ... View more

I have the following dataset (forgive the "fake" data) and want to merge the Content column (and have the data separated by a comma) based on the Type column. Building     Type     Content A22          Office     chair A22          Office     desk A22          Res.       bed A25          Res.       bed A25          Res.       lamp A26          Office     chair A26          Res.       chair A26          Res.       bed A26          Res.       lamp I want to produce the following output: Building Type Content A22 Office chair, desk A22 Res. bed A25 Res. bed, lamp A26 Office chair, desk A26 Res. chair, bed, lamp Is there a way to do this in proc report, or should I merge the content cells in a data step? ... View more

I have a graph that drills down into tables, that then drill down into further tables. I can get the chart links to work, but cannot figure out how to link the 1st table info to the 2nd. I want to click on Building in table 1 and have that drill down into the appropriate building number in table 2. Chart code: /*  if (TSG="A1") then TSGG='HREF="TSGG1.htm"'; etc.*/ proc gchart data=chart; hbar protocol/ sumvar=value group=TSG subgroup=step nozero sum sumlabel='Total Days' descending maxis=axis1 raxis=axis2 gaxis=axis3 legend=legend1 html=TSGG html_legend=TSGG; run; quit; table 1 code: %macro do_TSG(TSG);     ods html file="&TSG..htm" path=odsout style=listing;     title1 "Development Timeline Milestones for Building ";   proc report data=report nowd split='/';   where TSG="&TSG";   columns  building TSG Group;   define building/display "Building"   define TSG/ display "TSG Group";   .... run; %mend do_TSG; %do_TSG (X1);   Table 2 code: ODS HTML BODY='&Building..html' PATH=odsout; %macro do_build(building);    /* Open ODS HTML destination. Use the region name as the filename */    ods html file="&building..htm" path=odsout style=listing;   /* Set the axis label and title */     title1 "Comments for Bulding &Building ";   proc report data=comment nowd split='/';   where Building="&Building";   columns  building Date Comments;   define building/ display "Building";   define date/ display "Date";   define Comments/ display "Comments"; run;    /* Close the ODS HTML destination */    ods html close; %mend do_building; %do_building (A11); ... View more