topic Re: Proc print question in SAS Programming

Proc print question

ssitharath0420 — Mon, 22 Feb 2021 18:13:33 GMT

Hello, I am trying to relable my column and name the sum label to total instead of blank in the proc print statement but it doesn't seem to be working. What am I missing?

proc print data=work.Table1_Final noobs sumlabel='Total';
sum P1 P2 P3 P4;
title "TABLE 1: # of Members Filling Opioids";
label p1='7/1/20 - 12/31/2020'
label p2='4/1/20 - 09/30/2020'
label p3='1/1/20 - 06/30/2020'
label p4='10/1/19 - 03/31/2020';
run;

Re: Proc print question

ballardw — Mon, 22 Feb 2021 19:10:24 GMT

SUMLABEL from the documentation:

SUMLABEL

NOSUMLABEL

SUMLABEL='label'

specifies whether to display a label on the summary line for a BY group.

So without a BY statement has no effect.

You have a couple of options, one would be to add a dummy variable to use as a "by" variable so sum label works.

Another would be to move to Proc Report which has a more robust set of text controls.

Choices can depend on what other variables are in your data and need to be displayed.

I might guess that you manually summarized the data to get your P1 to P4 variables. That could likely be done directly in a report procedure like Proc Report or Tabulate from raw data as long as you have a date variable.

Re: Proc print question

Reeza — Mon, 22 Feb 2021 19:52:23 GMT

You may need to add the LABEL option in PROC PRINT as well.

proc print data=work.Table1_Final noobs sumlabel='Total' label;

@ssitharath0420 wrote:

Hello, I am trying to relable my column and name the sum label to total instead of blank in the proc print statement but it doesn't seem to be working. What am I missing?

proc print data=work.Table1_Final noobs sumlabel='Total';
sum P1 P2 P3 P4;
title "TABLE 1: # of Members Filling Opioids";
label p1='7/1/20 - 12/31/2020'
label p2='4/1/20 - 09/30/2020'
label p3='1/1/20 - 06/30/2020'
label p4='10/1/19 - 03/31/2020';
run;