Data visualization with SAS programming

sgpanel head issue

Reply
Frequent Contributor
Posts: 94

sgpanel head issue

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;

Capture.JPG

Esteemed Advisor
Posts: 5,403

Re: sgpanel head issue

Posted in reply to Niugg2010

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;

SGPanel7.png

 

PG
Frequent Contributor
Posts: 94

Re: sgpanel head issue

PG,

 

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

 

George

Ask a Question
Discussion stats
  • 2 replies
  • 117 views
  • 1 like
  • 2 in conversation