<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: data label in proc sgplot in SAS Programming</title>
    <link>https://communities.sas.com/t5/SAS-Programming/data-label-in-proc-sgplot/m-p/715239#M220915</link>
    <description>&lt;P&gt;It is real uneasy. Maybe somebody could point you a simple solution.&lt;/P&gt;
&lt;PRE&gt;&lt;CODE class=" language-sas"&gt;ods select none;
ods output sgplot=sgplot;
proc sgplot data = sashelp.heart;
histogram weight/datalabel ;
density weight;
density weight/type= kernel;
keylegend / location=inside position=topright;
run;
ods select all;

data a;
 set sgplot;
 _BIN_WEIGHT_DATALABELTYPE=BIN_WEIGHT_DATALABELTYPE_Auto__Y+0.5;
 if not missing( BIN_WEIGHT_DATALABELTYPE_Auto__X );
 keep BIN_WEIGHT_DATALABELTYPE_Auto__X BIN_WEIGHT_DATALABELTYPE_Auto__Y BIN_WEIGHT_DATALABELTYPE_Auto_DL
_BIN_WEIGHT_DATALABELTYPE;
 format BIN_WEIGHT_DATALABELTYPE_Auto_DL 8.2;
run;
data b;
 set sgplot;
 if not missing(NORMLD_WEIGHT___X);
 keep NORMLD_WEIGHT___X NORMLD_WEIGHT___Y;
run;
data c;
 set sgplot;
 if not missing(KERNEL_WEIGHT___X) ;
 keep KERNEL_WEIGHT___X KERNEL_WEIGHT___Y;
run;

proc sql;
create table temp as
select a.*,NORMLD_WEIGHT___Y 
 from a,b
  group by BIN_WEIGHT_DATALABELTYPE_Auto__X
   having abs(BIN_WEIGHT_DATALABELTYPE_Auto__X-NORMLD_WEIGHT___X) =
     min(abs(BIN_WEIGHT_DATALABELTYPE_Auto__X-NORMLD_WEIGHT___X));

create table have as
select temp.*,KERNEL_WEIGHT___Y 
 from temp,c
  group by BIN_WEIGHT_DATALABELTYPE_Auto__X
   having abs(BIN_WEIGHT_DATALABELTYPE_Auto__X-KERNEL_WEIGHT___X) =
     min(abs(BIN_WEIGHT_DATALABELTYPE_Auto__X-KERNEL_WEIGHT___X));
quit;


proc sgplot data=have;
vbarparm category= BIN_WEIGHT_DATALABELTYPE_Auto__X response=BIN_WEIGHT_DATALABELTYPE_Auto__Y / barwidth=1 ;
scatter x=BIN_WEIGHT_DATALABELTYPE_Auto__X y=_BIN_WEIGHT_DATALABELTYPE/ 
 markerchar=BIN_WEIGHT_DATALABELTYPE_Auto_DL discreteoffset=-0.1 ;
series x= BIN_WEIGHT_DATALABELTYPE_Auto__X y=NORMLD_WEIGHT___Y /
 name='normal' legendlabel='Normal' smoothconnect lineattrs=graphdata1(thickness=3);
series x= BIN_WEIGHT_DATALABELTYPE_Auto__X y=KERNEL_WEIGHT___Y /
 name='kernel' legendlabel='Kernel' smoothconnect lineattrs=graphdata2(thickness=3);
keylegend 'normal' 'kernel'/position=ne location=inside;
run;
&lt;/CODE&gt;&lt;/PRE&gt;
&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="SGPlot29.png" style="width: 640px;"&gt;&lt;img src="https://communities.sas.com/t5/image/serverpage/image-id/54068i6C9FA891B40901CE/image-size/large?v=v2&amp;amp;px=999" role="button" title="SGPlot29.png" alt="SGPlot29.png" /&gt;&lt;/span&gt;&lt;/P&gt;</description>
    <pubDate>Fri, 29 Jan 2021 12:26:34 GMT</pubDate>
    <dc:creator>Ksharp</dc:creator>
    <dc:date>2021-01-29T12:26:34Z</dc:date>
    <item>
      <title>data label in proc sgplot</title>
      <link>https://communities.sas.com/t5/SAS-Programming/data-label-in-proc-sgplot/m-p/715156#M220875</link>
      <description>&lt;P&gt;The orientation of the label in proc sgplot is vertical. How can I change the label into horizontal?&lt;/P&gt;&lt;PRE&gt;proc sgplot data = baseline;
histogram salary/datalabel;
density salary;
density salary/type= kernal;
keylegend / location=inside position=topright;
run;&lt;/PRE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Fri, 29 Jan 2021 01:38:30 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Programming/data-label-in-proc-sgplot/m-p/715156#M220875</guid>
      <dc:creator>gx2144</dc:creator>
      <dc:date>2021-01-29T01:38:30Z</dc:date>
    </item>
    <item>
      <title>Re: data label in proc sgplot</title>
      <link>https://communities.sas.com/t5/SAS-Programming/data-label-in-proc-sgplot/m-p/715158#M220876</link>
      <description>&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="gx2144_0-1611884347279.png" style="width: 400px;"&gt;&lt;img src="https://communities.sas.com/t5/image/serverpage/image-id/54054i560E1EBD1DD1BFAE/image-size/medium?v=v2&amp;amp;px=400" role="button" title="gx2144_0-1611884347279.png" alt="gx2144_0-1611884347279.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Fri, 29 Jan 2021 01:39:12 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Programming/data-label-in-proc-sgplot/m-p/715158#M220876</guid>
      <dc:creator>gx2144</dc:creator>
      <dc:date>2021-01-29T01:39:12Z</dc:date>
    </item>
    <item>
      <title>Re: data label in proc sgplot</title>
      <link>https://communities.sas.com/t5/SAS-Programming/data-label-in-proc-sgplot/m-p/715239#M220915</link>
      <description>&lt;P&gt;It is real uneasy. Maybe somebody could point you a simple solution.&lt;/P&gt;
&lt;PRE&gt;&lt;CODE class=" language-sas"&gt;ods select none;
ods output sgplot=sgplot;
proc sgplot data = sashelp.heart;
histogram weight/datalabel ;
density weight;
density weight/type= kernel;
keylegend / location=inside position=topright;
run;
ods select all;

data a;
 set sgplot;
 _BIN_WEIGHT_DATALABELTYPE=BIN_WEIGHT_DATALABELTYPE_Auto__Y+0.5;
 if not missing( BIN_WEIGHT_DATALABELTYPE_Auto__X );
 keep BIN_WEIGHT_DATALABELTYPE_Auto__X BIN_WEIGHT_DATALABELTYPE_Auto__Y BIN_WEIGHT_DATALABELTYPE_Auto_DL
_BIN_WEIGHT_DATALABELTYPE;
 format BIN_WEIGHT_DATALABELTYPE_Auto_DL 8.2;
run;
data b;
 set sgplot;
 if not missing(NORMLD_WEIGHT___X);
 keep NORMLD_WEIGHT___X NORMLD_WEIGHT___Y;
run;
data c;
 set sgplot;
 if not missing(KERNEL_WEIGHT___X) ;
 keep KERNEL_WEIGHT___X KERNEL_WEIGHT___Y;
run;

proc sql;
create table temp as
select a.*,NORMLD_WEIGHT___Y 
 from a,b
  group by BIN_WEIGHT_DATALABELTYPE_Auto__X
   having abs(BIN_WEIGHT_DATALABELTYPE_Auto__X-NORMLD_WEIGHT___X) =
     min(abs(BIN_WEIGHT_DATALABELTYPE_Auto__X-NORMLD_WEIGHT___X));

create table have as
select temp.*,KERNEL_WEIGHT___Y 
 from temp,c
  group by BIN_WEIGHT_DATALABELTYPE_Auto__X
   having abs(BIN_WEIGHT_DATALABELTYPE_Auto__X-KERNEL_WEIGHT___X) =
     min(abs(BIN_WEIGHT_DATALABELTYPE_Auto__X-KERNEL_WEIGHT___X));
quit;


proc sgplot data=have;
vbarparm category= BIN_WEIGHT_DATALABELTYPE_Auto__X response=BIN_WEIGHT_DATALABELTYPE_Auto__Y / barwidth=1 ;
scatter x=BIN_WEIGHT_DATALABELTYPE_Auto__X y=_BIN_WEIGHT_DATALABELTYPE/ 
 markerchar=BIN_WEIGHT_DATALABELTYPE_Auto_DL discreteoffset=-0.1 ;
series x= BIN_WEIGHT_DATALABELTYPE_Auto__X y=NORMLD_WEIGHT___Y /
 name='normal' legendlabel='Normal' smoothconnect lineattrs=graphdata1(thickness=3);
series x= BIN_WEIGHT_DATALABELTYPE_Auto__X y=KERNEL_WEIGHT___Y /
 name='kernel' legendlabel='Kernel' smoothconnect lineattrs=graphdata2(thickness=3);
keylegend 'normal' 'kernel'/position=ne location=inside;
run;
&lt;/CODE&gt;&lt;/PRE&gt;
&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="SGPlot29.png" style="width: 640px;"&gt;&lt;img src="https://communities.sas.com/t5/image/serverpage/image-id/54068i6C9FA891B40901CE/image-size/large?v=v2&amp;amp;px=999" role="button" title="SGPlot29.png" alt="SGPlot29.png" /&gt;&lt;/span&gt;&lt;/P&gt;</description>
      <pubDate>Fri, 29 Jan 2021 12:26:34 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Programming/data-label-in-proc-sgplot/m-p/715239#M220915</guid>
      <dc:creator>Ksharp</dc:creator>
      <dc:date>2021-01-29T12:26:34Z</dc:date>
    </item>
  </channel>
</rss>

