topic Re: How to Remove PROC title from Output? in SAS Programming

How to Remove PROC title from Output?

missamyyu — Thu, 10 Dec 2020 15:42:03 GMT

Hello!

I've written a macro program and was wondering if there was a way to remove the title "The MEANS Procedure" from the output of the summary statistic portion (PROC MEANS) without using an ODS statement outside of the macro programming. Thank you in advance for your time!

ODS NOPROCTITLE;
%MACRO	HS	 (DSNm = , Vbl = , Stats = N MEAN STDDEV,
						 NDec = 1);
						 
TITLE1 "Summary Statistics for '&Vbl.' from Data Set '&DSNm'" ITALIC;
PROC MEANS 
		DATA = &DSNm
		MAXDEC = &NDec
		&Stats;
	VAR	&Vbl;
	RUN;
TITLE;

%MEND	HS;
ODS;


%HS (DSNm = work.test, Vbl = WtLb, Stats = Q1 MEDIAN Q3, NDec = 0)

Re: How to Remove PROC title from Output?

andreas_lds — Tue, 08 Dec 2020 05:56:39 GMT

If you don't want to see the proc-title, you have to use "ods noproctitle". But you could, of course move the ods-statement into the macro. Unfortunately, it seems that no function exists to check how an ods option is set. For normal options you could use the function getoption in a data-step to backup the original value, change it to fit your needs and revert back to the original setting at the end of you macro. To bad, that such a function doesn't exist for the ods-options, at least i haven't found one.

Re: How to Remove PROC title from Output?

missamyyu — Wed, 09 Dec 2020 01:47:33 GMT

Thank you so much! I appreciate your time. Yes, I wish such a function exists!

Amy