NeilH Tracker

Re: Proc odstext produces uneven spacing in PDF output using inline style

NeilH — Wed, 09 Oct 2024 15:49:04 GMT

This simple addition suggested to me from SAS technical support did the trick - adding 'dpi=600' to the ods pdf statement like this:

ods pdf file="&folder&filename&extension" startpage=no dpi=600;

Re: Proc odstext produces uneven spacing in PDF output using inline style

NeilH — Wed, 02 Oct 2024 14:47:09 GMT

It is a bit frustrating. : ) All good thoughts, but at this point, I'm checking to see if there's a way to correct the spacing with the bold, italics, ... w/o changing anything else about the text. From what I've seen in responses to a couple of past similar questions, there may not be a straightforward solution due to font incompatibilities, as you point out. But if someone has worked it out, I'd welcome hearing. Thanks.

Re: Proc odstext produces uneven spacing in PDF output using inline style

NeilH — Wed, 02 Oct 2024 14:16:34 GMT

@ballardw. thanks for the quick reply. I've bumped into the same problem with italics and underlining. So it's not specific to bold. And I do need to create a PDF directly.

Proc odstext produces uneven spacing in PDF output using inline style

NeilH — Tue, 01 Oct 2024 18:31:40 GMT

I'm trying to write to a pdf file using proc odstext and getting additional spaces before some of the words I'm applying the inline style to. This seems to occur regardless of the actual style attribute (bold, italic, underline, ...). I noticed an almost identical post (https://communities.sas.com/t5/ODS-and-Base-Reporting/ODS-TEXT-produces-uneven-spacing-in-PDF-output-using-inline/td-p/302373) from some years back that wasn't resolved. And another post that mentions some Microsoft specific fonts causing issues.

The issue doesn't occur without the inline style command or with html output to the browser rather than creating a pdf. It also doesn't matter whether the text comes from a macro variable or not.

I'm including code and example output. You can see the additional spaces before some of the bolded numbers in the text. I appreciate anyone's thoughts on this matter. Thanks.

%let school = "Acme U";
goptions reset=all device=SASPRTC;
ods _ALL_ close;
%let folder = M:\Engagement Surveys - 2024\Scratch\;
%let filename = %sysfunc(dequote(&school));
%let extension = .pdf;
options nodate;
ods pdf file="&folder&filename&extension" startpage=no;

data _null_;
set qc_temp1;
call symputx('faculty', f_count);
call symputx('students', s_count);
run;

ods proclabel = "Introduction";
proc odstext pagebreak = YES;
ods escapechar='^';

p
"Nationally, ^{style[font_weight=Bold]134} member institutions responded to the survey. Across those institutions, 
^{style[font_weight=Bold]675} individual faculty members and ^{style[font_weight=Bold]1,124} 
students responded. At your institution, ^{style[font_weight=Bold]&faculty.} faculty and ^{style[font_weight=Bold]&students.} 
students responded." /
style = {font_size=14pt just=l width=100%};

run;

ods pdf close; 
ods listing;

Re: Headers and Footers in PDF Output on pages with SGPLOT

NeilH — Tue, 17 Sep 2024 19:35:52 GMT

Thanks, I'll check it out. I also found this paper:
https://support.sas.com/resources/papers/proceedings19/3644-2019.pdf

Re: Headers and Footers in PDF Output on pages with SGPLOT

NeilH — Tue, 17 Sep 2024 17:24:32 GMT

Definitely agree @Quentin, separating the graph title and footnote from the header/footer on a page would be a very nice add in SAS. But your solution gets me very close, so thank you for that. I just need to investigate the sganno option further to work out the placement of both the graph title and footnote on the graph. I'm seeing that there can be multiple rows of text data in the dataset that gets referenced by the option.

Re: Headers and Footers in PDF Output on pages with SGPLOT

NeilH — Tue, 17 Sep 2024 13:50:49 GMT

Thank you for your response. I do see how setting the title and footnote at the beginning will display it on each page. The issue that I still have - and seen on your output - is that the title and footnote of the sgplot should only appear as part of the chart rather than on each page as well. Is there a way to treat the title and footnote specific to the sgplot calls separately from the global header/footer that appears on every page of the output?

Header on every page:

Footer on every page:

And then on the pages with sgplot output, in addition to the global header/footer, display the title and footnote of the graph within its borders.

Headers and Footers in PDF Output on pages with SGPLOT

NeilH — Mon, 16 Sep 2024 21:12:52 GMT

Hello,

I'm trying to create pdf output that includes multiple runs of sgplot so that the same global header and footer appears on every page. I can get them to appear on pages with only text, but am not sure how to display them on pages with sgplot output. The sgplots themselves have titles and footers within their borders.

In the example below, the header and footnote print on the title page. I would like them to also appear in the subsequent page with the sgplot output. The actual report would have many sgplot calls.

I appreciate anyone's insight on this. Thanks.

/* Create test dataset */
data test1;
input var $ rating1 survey $ source $ section $;
datalines;
f_pr_inst_mean   68 Faculty Acme U  Program
f_pr_national_mean 79 Faculty National Program
s_pr_inst_mean  81 Student Acme U  Program
s_pr_national_mean 78 Student National Program
f_fa_inst_mean  78 Faculty Acme U  Faculty
f_fa_national_mean 86 Faculty National Faculty
s_fa_inst_mean  89 Student Acme U  Faculty
s_fa_national_mean 83 Student National Faculty
f_in_inst_mean  77 Faculty Acme U  Institution
f_in_national_mean 69 Faculty National Institution
s_in_inst_mean  66 Student Acme U  Institution
s_in_national_mean 76 Student National Institution
f_le_inst_mean  89 Faculty Acme U  Leadership
f_le_national_mean 78 Faculty National Leadership
f_ed_inst_mean  75 Faculty Acme U  Education
f_ed_national_mean 84 Faculty National Education
s_ed_inst_mean  83 Student Acme U  Education
s_ed_national_mean 73 Student National Education
;
run;


/* Output to pdf */
%let school = "Acme U";
goptions reset=all device=SASPRTC;
ods _ALL_ close; 
%let folder = M:\Engagement Surveys - 2024\Scratch\;
%let filename = %sysfunc(dequote(&school));
%let extension = .pdf;
ods pdf (id=1) file="&folder&filename&extension";
options nodate;


/* Title page with header and footer */
proc odstext;
ods escapechar='~';
title j=r "~S={preimage='C:\Users\nhurwitz\OneDrive - ACAPT\Documents\CoE logo.png' just=c}";
footnote justify=c height=6pt color=black
"©2024: Engagement Survey from  American Council of Academic Physical Therapy (ACAPT – www.acapt.org/excellence) All rights reserved – September 2024)"; 

p '2024 ENGAGEMENT SURVEY MEMBER REPORT:' /
style = {font_weight=bold font_size=18pt just=c width=100% verticalalign=top};
p &school /
style = {font_weight=bold font_size=16pt just=c width=100%};


/* Sgplot on separate page - no header or footer currently */
ods proclabel = "Section Charts";
proc sgplot data=test1 description="Faculty Survey Response by Section: Institution vs. National";
styleattrs DATACOLORS=(CX94c25b CX8e4133);
title 'Faculty Survey Response by Section: Institution vs. National'; 
where survey = 'Faculty';
vbar section / response=rating1 datalabel=rating1 group=source groupdisplay=cluster clusterwidth=.50 name="vbars";
yaxis label='Level of Agreement' values=(0, 33, 67, 100, 110) valuesdisplay=("Disagree (0)" "Somewhat Disagree (33)" "Somewhat Agree (67)" "Agree (100)");
xaxis display=(nolabel);
keylegend "vbars" / title="";
footnote height=.75 "Bar values represent the average responsive value of students or faculty members across questions in the section";

ods html(id=1) close;

Re: Formatting PDF output to appear as HTML output

NeilH — Wed, 14 Aug 2024 18:41:53 GMT

Thanks, that's helpful. Changing the pdf style to Htmlblue does change the coloring scheme, so it's definitely having an effect. Although the title and y-axis labels still appear to be left justified - or just out of alignment compared to the html output. Exactly as before for the text positioning. I don't know if there are other ods commands that need to be called to reposition the title and y-axis label text into more standard positions.

ods html close;
ods pdf file='M:\Engagement Surveys - 2024\Scratch\output.pdf' style=HTMLBlue;
proc sgplot data=rc_temp6;
title 'Faculty Survey Response by Section: Institute vs. National'; 
where survey = 'Faculty';
vbar section / response=rating1 datalabel=rating1 group=source groupdisplay=cluster clusterwidth=.50;
yaxis label='Level of Agreement' values=(0, 33, 67, 100) valuesdisplay=("Disagree (0)" "Somewhat Disagree (33)" "Somewhat Agree (67)" "Agree (100)");
xaxis display=(nolabel);
footnote "N: Institute = 10, National = 100";
run;

Formatting PDF output to appear as HTML output

NeilH — Wed, 14 Aug 2024 17:13:59 GMT

Hello - I'm creating a bar chart with sgplot that produces both html and pdf output. The html formatting is perfect on-screen, while the pdf doesn't display nearly as well, having both layout (title, y-axis labels) and font differences. I'm attaching both charts below. Are there ODS commands - or another way - to guide the pdf formatting so that it appears nearly identical to the html output? I appreciate anyone's help with this. Thanks.

proc sgplot data=rc_temp6;
title 'Faculty Survey Response by Section: Institute vs. National'; 
where survey = 'Faculty';
vbar section / response=rating1 datalabel=rating1 group=source groupdisplay=cluster clusterwidth=.50;
yaxis label='Level of Agreement' values=(0, 33, 67, 100) valuesdisplay=("Disagree (0)" "Somewhat Disagree (33)" "Somewhat Agree (67)" "Agree (100)");
xaxis display=(nolabel);
footnote "N: Institute = 10, National = 100";
run;

Re: Label Vertices of Radar Chart

NeilH — Mon, 29 Jul 2024 20:21:06 GMT

Thank you!

Label Vertices of Radar Chart

NeilH — Mon, 29 Jul 2024 18:37:50 GMT

Hello, is it possible to label the values of the vertices of a radar chart similar to how the bars of a bar chart can be labeled with their values? In this example, the values 68.1 and 79.7 would be labeled along the Program dimension (section variable). I understand it's not quite the same, but wanted to check if it was possible. Thanks.

data rc_temp5;
input var $ rating1 survey $ source $ section $;
cards;
f_pr_inst_mean  68.1 Faculty Institute Program
f_pr_national_mean 79.7 Faculty National Program
f_fa_inst_mean  78.6 Faculty Institute Faculty
f_fa_national_mean 86.3 Faculty National Faculty
f_in_inst_mean  76.0 Faculty Institute Institution
f_in_national_mean 67.3 Faculty National Institution
f_le_inst_mean  88.9 Faculty Institute Leadership
f_le_national_mean 76.8 Faculty National Leadership
f_ed_inst_mean  75.2   Faculty Institute Education
f_ed_national_mean 84.0 Faculty National Education
;
run;

proc gradar data=rc_temp5;
where survey = 'Faculty';
chart section / 
freq=rating1 
overlay=source
cstarfill=(CX7C95CA CXDE7E6F)
starfill=(empty empty)
cframe= beige
;
run;

Re: Clustered Bar Chart not Not Displaying as Expected

NeilH — Thu, 25 Jul 2024 14:55:27 GMT

Thanks for the tip. I edited my post to paste in the code.

Re: Clustered Bar Chart not Not Displaying as Expected

NeilH — Thu, 25 Jul 2024 14:54:39 GMT

Thank you, Rick. That worked!

Clustered Bar Chart not Not Displaying as Expected

NeilH — Thu, 25 Jul 2024 14:45:03 GMT

I'm trying to create a clustered bar chart where the two bars within each cluster are side by side without space in between. My code is separating the clusters by bar color, but doesn't seem to be doing it spatially. I've tried adjusting both the barwidth and clusterwidth options unsuccessfully. They both seem to be affecting just the bar widths. I appreciate assistance on getting the display right. My data, code, and results are below. Thanks.

InstAll	pr1	d1	survey
f_pr_score1	25	25.0	Faculty
s_pr_score1	55.66666667	55.7	Student
f_pr_mean1	59.86574737	59.9	Faculty
s_pr_mean1	60.67674272	60.7	Student

data temp4;
input install $11. pr1 d1 survey $;
cards;
f_pr_score1 25 25.0 Faculty
s_pr_score1 55.66666667 55.7 Student
f_pr_mean1 59.86574737 59.9 Faculty
s_pr_mean1 60.67674272 60.7 Student
;
run;

proc sgplot data=temp4;
title 'A student body that reflects the diversity of society at large';
vbar install / response=pr1 datalabel=d1 barwidth=.25 group=survey groupdisplay=cluster;
yaxis label='Rating';
xaxis values=('f_pr_score1' 'f_pr_mean1' 's_pr_score1' 's_pr_mean1') 
	  valuesdisplay=('Faculty Rating' 'Faculty National Mean' 'Student Rating' 'Student National Mean')
 	  display=(nolabel);
run;

Re: Creating a single bar chart from multiple variables

NeilH — Wed, 01 May 2024 15:50:02 GMT

Perfect! Thank you.

Re: Creating a single bar chart from multiple variables

NeilH — Wed, 01 May 2024 14:38:51 GMT

Worked perfectly, Reeza!

My one issue with the current labels I have, is that a few of them are quite long and crowd out the chart. I'll research this, but if you know of a word wrap option that can be applied to the labels in sgplot or an alternative, that would be great. I think I see how to add a line break in the label itself when it's set - (*ESC*){unicode '000a'x}. But it's not appearing as I'd hope in the chart itself. Below is an example of a lengthy label without a newline in it. The chart displays perfectly for shorter labels.

Re: Creating a single bar chart from multiple variables

NeilH — Tue, 30 Apr 2024 16:12:24 GMT

Hi Reeza,

Your solution to my bar chart question was elegant and works. One minor additional question. Is it possible to display the labels I have for options1-options4 for the x-axis labeling rather than the variable names?

My code based on your answer is what I have below. Both q_7760_bn1 and q7760_bn2 have labels associated with them from the original dataset (ips.allvars3) that I see with a proc contents on summary_results.

Thanks.

ods select none;
ods output summary=summary_results;
proc means data=ips.allvars3 stackods mean;
var q7760_bn1 q7760_bn2;
run;
ods select all;

proc sgplot data=summary_results;
vbarparm response=mean category=variable;
format mean percent12.1;
label mean = 'Response';
run;

Re: Creating a single bar chart from multiple variables

NeilH — Tue, 30 Apr 2024 15:38:02 GMT

Thank you. That's perfect!

Re: Creating a single bar chart from multiple variables

NeilH — Tue, 30 Apr 2024 15:04:41 GMT

Your solution works just about perfectly for me. Is it possible just to display the % of 1s in the bars rather than having them as stacked bars that total 100%?