topic Re: Bar chart with sgplot in Graphics Programming

Bar chart with sgplot

PSIOT — Thu, 29 Jun 2017 08:17:49 GMT

Dear all,

I would like to change the labels of each bar but keeping same order of procedure.

Please find my code:

proc sgplot data=toto noborder;
styleattrs datacolors=(Firebrick big vpap deepskyblue ) ;
vbar patient / response=time /*stat=sum*/
group=procedure fil barwidth=0.2 seglabel seglabelattrs=(color=white size=12 ) /*datalabel*/
baselineattrs=(thickness=0 ) groupdisplay=stack
outlineattrs=(color=cx3f3f3f);
keylegend / position=right;
xaxis display=(nolabel noline noticks);
yaxis label='Hours' grid;
title 'Procedure times';
run;

Please find below the graph inside attachments.

I would like to replace:

'01:Induction' by 'Induction'

'02:Incis_CPB' by 'Incision to CPB'

'03:CPBDurati' by 'CPB duration'

'04:skin_clos' by CPB stop to skin closure

Thank all for your support,

Bar chart with Sgplot

PSIOT — Thu, 29 Jun 2017 08:19:32 GMT

Dear all,

I would like to change the labels of each bar but keeping same order of procedure.

Please find my code:

Please find below the graph inside attachments.

I would like to replace:

'01:Induction' by 'Induction'

'02:Incis_CPB' by 'Incision to CPB'

'03:CPBDurati' by 'CPB duration'

'04:skin_clos' by CPB stop to skin closure

Thank all for your support,

Re: Bar chart with sgplot

RW9 — Thu, 29 Jun 2017 09:06:59 GMT

The way to do this is to make your categories numeric, i.e. 1 for the first, 2 for the second etc. and apply a format to them with the full text. This way the data orders correctly per the numeric, and displays the full formatted value.

Re: Bar chart with sgplot

PSIOT — Thu, 29 Jun 2017 09:58:33 GMT

I do not used very often proc format.

I try this code but that does not work:

proc format lib=work;
value $ procedure '01:Induction' = 'Induction'
'02:Incis_CPB' = 'Incision to CPB'
'03:CPBDurati' = 'Incision to CPB'
'04:skin_clos' = 'CPB stop to skin closure';

run;

proc sgplot data=toto noborder;

styleattrs datacolors=(Firebrick big vpap deepskyblue ) ;
vbar patient / response=time /*stat=sum*/
group=procedure barwidth=0.2 seglabel seglabelattrs=(color=white size=10) /*datalabel*/
baselineattrs=(thickness=0 ) nooutline /*groupdisplay=stack*/
outlineattrs=(color=cx3f3f3f);
Format procedure;
keylegend / position=right;
xaxis display=(nolabel noline noticks);
yaxis label='Hours' grid;
title 'Procedure times';
run;

Re: Bar chart with sgplot

RW9 — Thu, 29 Jun 2017 10:40:49 GMT

Its a good idea to indicate "what doesn't work" in future. I guess its because you didn't apply the format:

proc format lib=work;
  value $procedure 
  '01:Induction' = 'Induction'
  '02:Incis_CPB' = 'Incision to CPB'
  '03:CPBDurati' = 'Incision to CPB'
  '04:skin_clos' = 'CPB stop to skin closure';
run;
 
title 'Procedure times';

proc sgplot data=toto noborder;
  styleattrs datacolors=(Firebrick big vpap deepskyblue ) ;
  vbar patient / response=time group=procedure barwidth=0.2 seglabel seglabelattrs=(color=white size=10)
    baselineattrs=(thickness=0 ) nooutline outlineattrs=(color=cx3f3f3f);
  format procedure $procedure.;
  keylegend / position=right;
  xaxis display=(nolabel noline noticks);
  yaxis label='Hours' grid;
run;

Note the format line.

Re: Bar chart with sgplot

PSIOT — Thu, 29 Jun 2017 11:42:27 GMT

Thank you