topic Re: Accessing BY Group in PROC REPORT COMPUTE Block in ODS and Base Reporting

Accessing BY Group in PROC REPORT COMPUTE Block

PaigeMiller — Thu, 24 Aug 2017 20:12:14 GMT

Here's what I'm trying to do in a very simplified example. For my PROC REPORT output, I want some columns of my output to be in italic if the BY group variable is a certain value, and otherwise not in italic. But the way I am doing it, it doesn't work, no italics appear and there is a message in the log. Code:

proc sort data=sashelp.class out=class;
	by sex;
run;
ods_html;
proc report data=class;
	by sex;
	columns name height weight;
	define name/group;
	compute height;
		if sex='F' then call define('_c2_',"style","style=[fontstyle=italic]");
	endcompute;
run;
ods html close;

Log:

1433  proc report data=class;
1434      by sex;
1435      columns name height weight;
1436      define name/group;
1437      compute height;
1438          if sex='F' then call define('_c2_',"style","style=[fontstyle=italic]");
1439      endcompute;
1440  run;

NOTE: Variable sex is uninitialized.
NOTE: The above message was for the following BY group:
      Sex=F
NOTE: Variable sex is uninitialized.
NOTE: The above message was for the following BY group:
      Sex=M
NOTE: There were 19 observations read from the data set WORK.CLASS.
NOTE: PROCEDURE REPORT used (Total process time):
      real time           0.04 seconds
      cpu time            0.03 seconds


1441  ods html close;

Can this work? How can I reference the BY variable in the COMPUTE block?

Re: Accessing BY Group in PROC REPORT COMPUTE Block

Shmuel — Thu, 24 Aug 2017 20:16:50 GMT

You got next message in the log:

NOTE: Variable sex is uninitialized.

I suppose you have to add SEX to COLUMNS staement ?!

Re: Accessing BY Group in PROC REPORT COMPUTE Block

ballardw — Thu, 24 Aug 2017 20:24:44 GMT

Proc report requires that any variable referenced in a calculation be to the left of the position it is being refenced. So you will want to add SEX to columns, left height. Set the option NOPRINT for SEX in a define block.

Such as

define sex /display noprint;

And you be a bit closer to your goal

Re: Accessing BY Group in PROC REPORT COMPUTE Block

PaigeMiller — Thu, 24 Aug 2017 21:56:48 GMT

Well, duh, I knew that but for some reason, I didn't think it applied to BY variables.

However, the code does what I want now. Thanks!

Re: Accessing BY Group in PROC REPORT COMPUTE Block

ballardw — Thu, 24 Aug 2017 21:59:51 GMT

@PaigeMiller wrote:

Well, duh, I knew that but for some reason, I didn't think it applied to BY variables.

However, the code does what I want now. Thanks!

I swear that I have absolutely, never ever had to say "I knew that but ..." about my code. Honest. Really.