BookmarkSubscribeRSS Feed
Niugg2010
Obsidian | Level 7

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

2 REPLIES 2
PGStats
Opal | Level 21

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
Niugg2010
Obsidian | Level 7

PG,

 

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

 

George

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1258 views
  • 1 like
  • 2 in conversation