topic Re: sgpanel head issue in Graphics Programming

sgpanel head issue

Niugg2010 — Mon, 07 May 2018 20:51:39 GMT

Please see below code and output.

The header was too long and was cut (red marked part). How can I change the header into two rows instead of one row?

Thanks

data x;set sashelp.prdsale;

format _year $200.;

where product in ("CHAIR" "SOFA");

_year="XXXXXXXXXXXXXXXXXXXXX This figure is for "||strip(year);

run;

ods rtf file="xxxx\try.rtf";

proc sgpanel data=x;

where product in ("CHAIR" "SOFA");

title "Yearly Sales by Product";

panelby _year / spacing=5 novarname;

vline month / response=actual group=product;

run;

title;

ods rtf close;

Re: sgpanel head issue

PGStats — Tue, 08 May 2018 03:13:46 GMT

I don't know how to do exactly that, but you might get away with:

data x;
set sashelp.prdsale;
format _year $200.;
  where product in ("CHAIR" "SOFA");
  _year1="XXXXXXXXX"||strip(year)||"XXXXXXXXXXXX";
  _year2="This figure is for "||strip(year);
run;

proc sgpanel data=x;
  where product in ("CHAIR" "SOFA");
  title "Yearly Sales by Product";
  panelby _year1 _year2 / spacing=5 novarname noheaderborder;
  vline month / response=actual group=product;
run;

Re: sgpanel head issue

Niugg2010 — Tue, 08 May 2018 13:17:49 GMT

PG,

Thanks. That is what I though also. Hopefully. someone has a better solution.

George