The SAS Output Delivery System and reporting techniques

Title in png extra spacing and Titles combined

Reply
New Contributor
Posts: 4

Title in png extra spacing and Titles combined

This is really two questions in one. I'm creating a png using an SGPLOT and am having a problem with my titles.

Title one comes out at the top but has a great deal of space after it before Title2. Then Title2 and Title3 are being combined on the same line.

Below is the code I'm using:

%IF &FILENM = SHARED %THEN %DO ;                                 

Title1 'CPC Shared Processor Engine Pools-LPAR Configuration';   

%END;                                                            

%ELSE %DO;                                                       

title1 'CPC Dedicated Processor Engine Pools-LPAR Configuration' ;

%END;                                                            

TITLE2 '#BYVAR(1) #BYVAL(1)';                                    

TITLE3 '#BYVAR(2) #BYVAL(2)';                                    

                                                                 

PROC SGPLOT DATA=WORK.&FILENM UNIFORM=YSCALE ;                   

                                                                 

BY CPCID DATE ;                                                  

  VBAR PRSMLPNM / RESPONSE=LPCAVCPU BARWIDTH=.16                 

  DATASKIN=none ;

...


Below is the resulting chart.

DEDICATE.png      

Any thoughts would be greatly appreciated.

Rodney                                   

Grand Advisor
Posts: 9,748

Re: Title in png extra spacing and Titles combined

Target destination? Are you sending this to PDF, RTF or HTML? Also which STYLE are you using?

And by any chance to you have a combination of data such that your first BY variable is missing when the second isn't?

Does this happen for all of the charts or just the first couple? That might lead me to strongly suspect the first BY variable is either blank or missing.

New Contributor
Posts: 4

Re: Title in png extra spacing and Titles combined

1. HTML

2. I was using the default style, but am now using a custom style, but it didn't have any impact.

3. No, The first BY variable is alway present. I did a PROC PRINT just to make sure.

4. It happens on all the charts.

Here is the style stuff relating to the titles:

STYLE FONTS FROM FONTS /                                       

"TITLEFONT" = ("VERDANA, VERDANA, HELVETICA, SANS-SERIF",18PT,BOLD)

"TITLEFONT2" = ("VERDANA, VERDANA, HELVETICA, SANS-SERIF",14PT,BOLD);

STYLE GRAPHFONTS FROM _SELF_/                                    

  "GRAPHTITLEFONT" = ("MICROSOFT SANS SERIF",9.5PT, BOLD)        

  "GRAPHTITLEFONT2" = ("ARIAL",10PT, BOLD)                       

  "GRAPHVALUEFONT" = ("ARIAL",8.25PT,NORMAL)                     

  "GRAPHLABELFONT" = ("ARIAL",8.25PT,NORMAL)                     

  "GRAPHFOOTNOTEFONT" = ("ARIAL",8.25PT,ITALIC);                

Rodney

New Contributor
Posts: 4

Re: Title in png extra spacing and Titles combined

1. HTML

2. I was using the default style, but am now using a custom style, but it didn't have any impact.

3. No, The first By variable is alway present.Use advanced editor4. It happens on all the charts.

Here is the style stuff relating to the titles:

STYLE FONTS FROM FONTS /                                        

"TITLEFONT" = ("VERDANA, VERDANA, HELVETICA, SANS-SERIF",18PT,BOLD)

"TITLEFONT2" = ("VERDANA, VERDANA, HELVETICA, SANS-SERIF",14PT,BOLD);

STYLE GRAPHFONTS FROM _SELF_/                                    

  "GRAPHTITLEFONT" = ("MICROSOFT SANS SERIF",9.5PT, BOLD)        

  "GRAPHTITLEFONT2" = ("ARIAL",10PT, BOLD)                       

  "GRAPHVALUEFONT" = ("ARIAL",8.25PT,NORMAL)                     

  "GRAPHLABELFONT" = ("ARIAL",8.25PT,NORMAL)                     

  "GRAPHFOOTNOTEFONT" = ("ARIAL",8.25PT,ITALIC);                 

New Contributor
Posts: 4

Re: Title in png extra spacing and Titles combined

Something I've noticed. Title2 and Title3 are not coming out at all, that is actually what the blank lines are and the line I'm getting seems to be auto generated somehow...

Grand Advisor
Posts: 9,748

Re: Title in png extra spacing and Titles combined

To suppress the automatic by line:

options nobyline; before the proc and turn back on afterwards with options byline.

Post a Question
Discussion Stats
  • 5 replies
  • 449 views
  • 0 likes
  • 2 in conversation