topic Re: SGPanel, Hbar Tooltip Override Feature Similar to the Series Plot Tooltip in Graphics Programming

topic Re: SGPanel, Hbar Tooltip Override Feature Similar to the Series Plot Tooltip in Graphics Programming https://communities.sas.com/t5/Graphics-Programming/SGPanel-Hbar-Tooltip-Override-Feature-Similar-to-the-Series-Plot/m-p/185038#M6814 <HTML><HEAD></HEAD><BODY><P>There is in SAS 9.4. Given the content of your SGPANEL request, you could write it in GTL and control the tip content there.</P></BODY></HTML> Thu, 15 Jan 2015 18:26:13 GMT DanH_sas 2015-01-15T18:26:13Z SGPanel, Hbar Tooltip Override Feature Similar to the Series Plot Tooltip https://communities.sas.com/t5/Graphics-Programming/SGPanel-Hbar-Tooltip-Override-Feature-Similar-to-the-Series-Plot/m-p/185037#M6813 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 11.0pt; font-family: 'Arial',sans-serif; color: black; background: white;">Is there a sgpanel, hbar tooltip override feature similar to the series plot tooltip override feature in SAS 9.2?</SPAN></P><P><SPAN style="font-size: 11.0pt; font-family: 'Arial',sans-serif; color: black; background: white;">Code without the tooltip feature is below:</SPAN></P><P><SPAN style="font-size: 11.0pt; font-family: 'Arial',sans-serif; color: black; background: white;"><BR /></SPAN></P><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: Arial, sans-serif;">/*ROLENAME=(Year=FOUR_DIGIT_YEAR Level=degree_level)</SPAN></P><P><SPAN style="font-size: 10pt; font-family: Arial, sans-serif;"> TIP=(Year Level Y) tiplabel=(Year='Academic Term' Y='Students Enrolled' Level ='Level') */;</SPAN></P><P></P><P>proc sql noprint;</P><P>CREATE TABLE enrollment (</P><P>  FOUR_DIGIT_YEAR varchar(50),</P><P>  STUDENTS_ENROLLED int,</P><P>  residency_desc varchar(50),</P><P>  degree_level varchar(50)</P><P>);<IMG alt="tooltip.png" class="jive-image-thumbnail jive-image" src="https://communities.sas.com/legacyfs/online/8717_tooltip.png" width="450" /></P><P></P><P></P><P>/*panel one data*/</P><P>INSERT INTO enrollment</P><P>  (FOUR_DIGIT_YEAR, STUDENTS_ENROLLED, residency_desc, degree_level)</P><P>VALUES</P><P>  ('2001', 234, '1', 'Bac');</P><P>INSERT INTO enrollment</P><P>  (FOUR_DIGIT_YEAR, STUDENTS_ENROLLED, residency_desc, degree_level)</P><P>VALUES</P><P>  ('2002', 345, '1', 'Bac');</P><P>INSERT INTO enrollment</P><P>  (FOUR_DIGIT_YEAR, STUDENTS_ENROLLED, residency_desc, degree_level)</P><P>VALUES</P><P>  ('2002', 584, '1', 'Master');</P><P></P><P></P><P>/*panel two data*/</P><P>INSERT INTO enrollment</P><P>  (FOUR_DIGIT_YEAR, STUDENTS_ENROLLED, residency_desc, degree_level)</P><P>VALUES</P><P>  ('2001', 465, '2', 'Bac');</P><P>INSERT INTO enrollment</P><P>  (FOUR_DIGIT_YEAR, STUDENTS_ENROLLED, residency_desc, degree_level)</P><P>VALUES</P><P>  ('2002', 344, '2', 'Bac');</P><P>INSERT INTO enrollment</P><P>  (FOUR_DIGIT_YEAR, STUDENTS_ENROLLED, residency_desc, degree_level)</P><P>VALUES</P><P>  ('2002', 200, '2', 'Master');</P><P>quit;</P><P></P><P>proc sgpanel data=enrollment;</P><P>  panelby residency_desc/ novarname uniscale=row  layout=columnlattice;</P><P>  rowaxis;</P><P>  hbar FOUR_DIGIT_YEAR / response=STUDENTS_ENROLLED stat=sum group=degree_level </P><P>  /*ROLENAME=(Year=FOUR_DIGIT_YEAR Level=degree_level)</P><P>  TIP=(Year Level Y) tiplabel=(Year='Academic Term' Y='Students Enrolled' Level ='Level') */;</P><P>  keylegend / position=right noborder;</P><P>run;</P></BODY></HTML> Thu, 15 Jan 2015 18:21:09 GMT https://communities.sas.com/t5/Graphics-Programming/SGPanel-Hbar-Tooltip-Override-Feature-Similar-to-the-Series-Plot/m-p/185037#M6813 DavidPhillips2 2015-01-15T18:21:09Z Re: SGPanel, Hbar Tooltip Override Feature Similar to the Series Plot Tooltip https://communities.sas.com/t5/Graphics-Programming/SGPanel-Hbar-Tooltip-Override-Feature-Similar-to-the-Series-Plot/m-p/185038#M6814 <HTML><HEAD></HEAD><BODY><P>There is in SAS 9.4. Given the content of your SGPANEL request, you could write it in GTL and control the tip content there.</P></BODY></HTML> Thu, 15 Jan 2015 18:26:13 GMT https://communities.sas.com/t5/Graphics-Programming/SGPanel-Hbar-Tooltip-Override-Feature-Similar-to-the-Series-Plot/m-p/185038#M6814 DanH_sas 2015-01-15T18:26:13Z Re: SGPanel, Hbar Tooltip Override Feature Similar to the Series Plot Tooltip https://communities.sas.com/t5/Graphics-Programming/SGPanel-Hbar-Tooltip-Override-Feature-Similar-to-the-Series-Plot/m-p/185039#M6815 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 11.0pt; font-family: 'Arial',sans-serif; color: black; background: white;">What does “write it in GTL" mean?  </SPAN></P></BODY></HTML> Thu, 15 Jan 2015 18:38:11 GMT https://communities.sas.com/t5/Graphics-Programming/SGPanel-Hbar-Tooltip-Override-Feature-Similar-to-the-Series-Plot/m-p/185039#M6815 DavidPhillips2 2015-01-15T18:38:11Z Re: SGPanel, Hbar Tooltip Override Feature Similar to the Series Plot Tooltip https://communities.sas.com/t5/Graphics-Programming/SGPanel-Hbar-Tooltip-Override-Feature-Similar-to-the-Series-Plot/m-p/185040#M6816 <HTML><HEAD></HEAD><BODY><P>The Graph Template Language (GTL). The template for you graph would look something like the following definition. Just add your tip control to the BARCHART statement, and use the template with PROC SGRENDER.</P><P></P><P>proc template;</P><P>define statgraph barchart;</P><P>begingraph;</P><P>   layout datalattice columnvar=residency_desc / rowdatarange=unionall columndatarange=union;</P><P>      layout prototype;</P><P>         barchart x=FOUR_DIGIT_YEAR y=STUDENTS_ENROLLED / stat=sum group=degree_level name="bar";</P><P>      endlayout;</P><P>      sidebar / align=right spacefill=false;</P><P>         discretelegend "bar" / border=false;</P><P>      endsidebar;</P><P>   endlayout;</P><P>endgraph;</P><P>end;</P><P>run;</P><P></P><P>proc sgrender data=somedata template=barchart; run;</P></BODY></HTML> Thu, 15 Jan 2015 19:13:46 GMT https://communities.sas.com/t5/Graphics-Programming/SGPanel-Hbar-Tooltip-Override-Feature-Similar-to-the-Series-Plot/m-p/185040#M6816 DanH_sas 2015-01-15T19:13:46Z Re: SGPanel, Hbar Tooltip Override Feature Similar to the Series Plot Tooltip https://communities.sas.com/t5/Graphics-Programming/SGPanel-Hbar-Tooltip-Override-Feature-Similar-to-the-Series-Plot/m-p/185041#M6817 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 11.0pt; font-family: 'Arial',sans-serif; color: black; background: white;"><IMG alt="tooltip2.png" class="jive-image-thumbnail jive-image" src="https://communities.sas.com/legacyfs/online/8722_tooltip2.png" width="450" /></SPAN></P><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 11.0pt; font-family: 'Arial',sans-serif; color: black; background: white;">The tooltip code does not error out here but it seems like it is not enabled.</SPAN></P><P><SPAN style="font-size: 11pt; font-family: Arial, sans-serif;"> </SPAN></P><P><SPAN style="font-size: 11pt; font-family: Arial, sans-serif;">proc template;</SPAN></P><P><SPAN style="font-size: 11pt; font-family: Arial, sans-serif;">define statgraph barchart;</SPAN></P><P><SPAN style="font-size: 11pt; font-family: Arial, sans-serif;">begingraph;</SPAN></P><P><SPAN style="font-size: 11pt; font-family: Arial, sans-serif;">   layout datalattice columnvar=residency_desc / rowdatarange=unionall columndatarange=union headerlabeldisplay=value;</SPAN></P><P><SPAN style="font-size: 11pt; font-family: Arial, sans-serif;">      layout prototype;</SPAN></P><P><SPAN style="font-size: 11pt; font-family: Arial, sans-serif;">         barchart x=FOUR_DIGIT_YEAR y=STUDENTS_ENROLLED / stat=sum group=degree_level name="bar" orient=horizontal   </SPAN></P><P><SPAN style="font-size: 11pt; font-family: Arial, sans-serif;">  TIP=(x Y) tiplabel=(x='Academic Term' Y='Students Enrolled');</SPAN></P><P><SPAN style="font-size: 11pt; font-family: Arial, sans-serif;">      endlayout;</SPAN></P><P><SPAN style="font-size: 11pt; font-family: Arial, sans-serif;">      sidebar / align=right spacefill=false;</SPAN></P><P><SPAN style="font-size: 11pt; font-family: Arial, sans-serif;">         discretelegend "bar" / border=false;</SPAN></P><P><SPAN style="font-size: 11pt; font-family: Arial, sans-serif;">      endsidebar;</SPAN></P><P><SPAN style="font-size: 11pt; font-family: Arial, sans-serif;">   endlayout;</SPAN></P><P><SPAN style="font-size: 11pt; font-family: Arial, sans-serif;">endgraph;</SPAN></P><P><SPAN style="font-size: 11pt; font-family: Arial, sans-serif;">end;</SPAN></P><P><SPAN style="font-size: 11pt; font-family: Arial, sans-serif;">run;</SPAN></P><P><SPAN style="font-size: 11pt; font-family: Arial, sans-serif;"> </SPAN></P><P><SPAN style="font-size: 11pt; font-family: Arial, sans-serif;">proc sgrender data=enrollment template=barchart; run;</SPAN></P></BODY></HTML> Thu, 15 Jan 2015 19:55:57 GMT https://communities.sas.com/t5/Graphics-Programming/SGPanel-Hbar-Tooltip-Override-Feature-Similar-to-the-Series-Plot/m-p/185041#M6817 DavidPhillips2 2015-01-15T19:55:57Z Re: SGPanel, Hbar Tooltip Override Feature Similar to the Series Plot Tooltip https://communities.sas.com/t5/Graphics-Programming/SGPanel-Hbar-Tooltip-Override-Feature-Similar-to-the-Series-Plot/m-p/185042#M6818 <HTML><HEAD></HEAD><BODY><P>On the ODS GRAPHICS statement, you have to have the IMAGEMAP option enabled:</P><P></P><P>ods graphics / imagemap;</P></BODY></HTML> Thu, 15 Jan 2015 19:57:45 GMT https://communities.sas.com/t5/Graphics-Programming/SGPanel-Hbar-Tooltip-Override-Feature-Similar-to-the-Series-Plot/m-p/185042#M6818 DanH_sas 2015-01-15T19:57:45Z Re: SGPanel, Hbar Tooltip Override Feature Similar to the Series Plot Tooltip https://communities.sas.com/t5/Graphics-Programming/SGPanel-Hbar-Tooltip-Override-Feature-Similar-to-the-Series-Plot/m-p/185043#M6819 <HTML><HEAD></HEAD><BODY><P>As an aside, you might want to put ACROSS=1 on the DISCRETELEGEND and REVERSE=TRUE on the ROWAXISOPTS to get back the original picture:</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: #ffffff;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: Arial, sans-serif;">proc template;</SPAN></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: #ffffff;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: Arial, sans-serif;">define statgraph barchart;</SPAN></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: #ffffff;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: Arial, sans-serif;">begingraph;</SPAN></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: #ffffff;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: Arial, sans-serif;">   layout datalattice columnvar=residency_desc / rowdatarange=unionall columndatarange=union headerlabeldisplay=value</SPAN></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: #ffffff;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: Arial, sans-serif;">                                                                             rowaxisopts=(reverse=true);</SPAN></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: #ffffff;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: Arial, sans-serif;">      layout prototype;</SPAN></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: #ffffff;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: Arial, sans-serif;">         barchart x=FOUR_DIGIT_YEAR y=STUDENTS_ENROLLED / stat=sum group=degree_level name="bar" orient=horizontal  </SPAN></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: #ffffff;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: Arial, sans-serif;">  TIP=(x Y) tiplabel=(x='Academic Term' Y='Students Enrolled');</SPAN></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: #ffffff;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: Arial, sans-serif;">      endlayout;</SPAN></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: #ffffff;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: Arial, sans-serif;">      sidebar / align=right spacefill=false;</SPAN></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: #ffffff;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: Arial, sans-serif;">         discretelegend "bar" / border=false across=1;</SPAN></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: #ffffff;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: Arial, sans-serif;">      endsidebar;</SPAN></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: #ffffff;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: Arial, sans-serif;">   endlayout;</SPAN></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: #ffffff;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: Arial, sans-serif;">endgraph;</SPAN></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: #ffffff;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: Arial, sans-serif;">end;</SPAN></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: #ffffff;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: Arial, sans-serif;">run;</SPAN></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: #ffffff;"> </P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: #ffffff;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: Arial, sans-serif;">proc sgrender data=enrollment template=barchart; run;</SPAN></P></BODY></HTML> Thu, 15 Jan 2015 20:06:59 GMT https://communities.sas.com/t5/Graphics-Programming/SGPanel-Hbar-Tooltip-Override-Feature-Similar-to-the-Series-Plot/m-p/185043#M6819 DanH_sas 2015-01-15T20:06:59Z