DATA Step, Macro, Functions and more

List Data formatting Subtotal

Reply
Contributor
Posts: 25

List Data formatting Subtotal

I am using the "list data wizard" in SAS EG 7.1 and having some trouble on formatting.

 

How do I change the output from printing the variable in the "Subtotal Of" to the word "subtotal"?

 

Example, I have the variable "At Risk" in the "subtotal of" role. The two values of at risk are "yes" or "no". In the output it is subtotaling these correctly, however instead of saying subtotal next to the values, it says the word "At Risk". I would like to change that to either say "Subtotal" or "Yes Subtotal" / "No Subtotal".

 

 

SAS Super FREQ
Posts: 8,868

Re: List Data formatting Subtotal

Posted in reply to Amber_Nicole94
Hi:
PROC REPORT gives you more control over this than PROC PRINT (List Data Wizard).

What code have you tried?

cynthia
Contributor
Posts: 25

Re: List Data formatting Subtotal

Posted in reply to Cynthia_sas
PROC SORT
	DATA=WORK.QUERY_FOR_APPEND_TABLE_0001(FIRSTOBS=1  KEEP="At Risk?"n Origin Destination Units "% OT"n "% <1"n "% <2"n "% <4"n "% <6"n "% <12"n "% <24"n "<48"n)
	OUT=WORK.SORTTempTableSorted
	;
	BY "At Risk?"n;
RUN;
TITLE;
TITLE1 "Report Listing";
FOOTNOTE;
FOOTNOTE1 "Generated by the SAS System (&_SASSERVERNAME, &SYSSCPL) on %TRIM(%QSYSFUNC(DATE(), NLDATE20.)) at %TRIM(%SYSFUNC(TIME(), TIMEAMPM12.))";

PROC PRINT DATA=WORK.SORTTempTableSorted
	NOOBS
	LABEL
	ROWS=PAGE
	;
	VAR "At Risk?"n Origin Destination Units "% OT"n "% <1"n "% <2"n "% <4"n "% <6"n "% <12"n "% <24"n "<48"n;
	BY "At Risk?"n;
	PAGEBY "At Risk?"n;
	SUM Units "% OT"n "% <1"n "% <2"n "% <4"n "% <6"n "% <12"n "% <24"n "<48"n;
	LABEL "At Risk?"n="   ";
RUN;
/* -------------------------------------------------------------------
   End of task code
   ------------------------------------------------------------------- */
RUN; QUIT;
%_eg_conditional_dropds(WORK.SORTTempTableSorted);
TITLE; FOOTNOTE;
Ask a Question
Discussion stats
  • 2 replies
  • 93 views
  • 0 likes
  • 2 in conversation