Help using Base SAS procedures

PROC MEANS doubles % signs in label?

Accepted Solution Solved
Reply
Highlighted
PROC Star
Posts: 1,449
Accepted Solution

PROC MEANS doubles % signs in label?

[ Edited ]

I'm running PROC MEANS on a labeled variable, that has a % in the label.  The output (both listing and ODS HTML) shows two percent signs.

 

proc means data=sashelp.class ;
  var age ;
  label age='My % label with %' ;
run ;

Returns:

                        The MEANS Procedure

             Analysis Variable : Age My %% label with %%

  N            Mean         Std Dev         Minimum         Maximum
 19      13.3157895       1.4926722      11.0000000      16.0000000
 

Any particular reason this happens, or way to avoid it?  PROC PRINT and PROC FREQ don't double the percent signs.

 

Above is from 9.4M4 on Win10.


Accepted Solutions
Solution
Thursday
PROC Star
Posts: 1,449

Re: PROC MEANS doubles % signs in label?

Tech support confirmed it is a known issue, and suggested the unicode workaround.  I recommended they add a problem note to document this (or expand the current note since the problem is not limited to FILE PRINT ODS).

 

They sent:

ods escapechar='^';
ods listing close;
ods pdf file='ctest.pdf';
 
proc means data=sashelp.class ;
  var age ;
  label age='My ^{unicode 0025} label with ^{unicode 0025}' ;
run ;


proc freq data=sashelp.class;
  tables name*sex ;
  label name='Name with ^{unicode 0025}' ;
  label sex='sex with ^{unicode 0025}' ;
run ;

ods pdf close;

View solution in original post


All Replies
Trusted Advisor
Posts: 1,158

Re: PROC MEANS doubles % signs in label?

Hi @Quentin,

 

This 2013/2014 thread suggests that it started with SAS 9.2 and this is also the first version where I saw it in PROC FREQ cross-tabulations, but not in univariate tables (!), and later in PROC MEANS. My attempt to write the percent sign as %sysfunc(byte(37)) failed. However, in the old thread a user joejw84 stated he had more luck using a unicode representation for ODS output, which I haven't tried yet.

PROC Star
Posts: 1,449

Re: PROC MEANS doubles % signs in label?

Posted in reply to FreelanceReinhard

Wow, I'm shocked this bug could have survived since 9.2.  I'll send it in to tech support, just in case the OP of that thread never did.

Super User
Posts: 13,304

Re: PROC MEANS doubles % signs in label?

This apparently is coming from the BASE.SUMMARY template in SASHELP.TMPLMST and the way the dynamic variable for labels is treated.

 

However I can't find anything in Proc Template documentation (which I hate digging through) for dynamic variables, which the Label is, for why this might happen as there is no actual manipulation of the label variable in the template.

 

You might be able to create a custom version of the template and change the code for the header to resemble the code for the LCLM and UCLM headers which do display a single %.

 

Or send the result to data set and use a Title statement to say the same thing with proc print.

 

PROC Star
Posts: 1,449

Re: PROC MEANS doubles % signs in label?

Thanks @ballardw.  In the older thread Cynthia Z pointed out this support note, http://support.sas.com/kb/18/708.html, also about % signs in labels being doubled in dynamic column headers, but the note suggests it's more limited scope.

Solution
Thursday
PROC Star
Posts: 1,449

Re: PROC MEANS doubles % signs in label?

Tech support confirmed it is a known issue, and suggested the unicode workaround.  I recommended they add a problem note to document this (or expand the current note since the problem is not limited to FILE PRINT ODS).

 

They sent:

ods escapechar='^';
ods listing close;
ods pdf file='ctest.pdf';
 
proc means data=sashelp.class ;
  var age ;
  label age='My ^{unicode 0025} label with ^{unicode 0025}' ;
run ;


proc freq data=sashelp.class;
  tables name*sex ;
  label name='Name with ^{unicode 0025}' ;
  label sex='sex with ^{unicode 0025}' ;
run ;

ods pdf close;
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 5 replies
  • 165 views
  • 3 likes
  • 3 in conversation