topic How to set the title quickly for proc means ? in SAS Programming

How to set the title quickly for proc means ?

Phil_NZ — Tue, 09 Mar 2021 05:48:30 GMT

Hi all SAS Users,

I want to ask your experience about how to set the title quickly for the output of a proc mean. Because sometimes I run a lot of proc means and I need to know the name of the dataset it is about.

So, normally, I use the title statement:

proc means data=have;
title "have";
run;

Could you please let me know if there is any way to set the title for the output of proc means without typing the statement title and else?

Warm regards.

Re: How to set the title quickly for proc means ?

SASKiwi — Tue, 09 Mar 2021 06:00:51 GMT

%macro Means (dataset = );

proc means data= &dataset;
title "&dataset";
run;

%mend Means;

%Means (dataset = Have);

Re: How to set the title quickly for proc means ?

Phil_NZ — Tue, 09 Mar 2021 06:17:42 GMT

Hi @SASKiwi

Thank you very much for the macro, but there would be some proc means I used different options (in one PROC MEAN I may use mean, max, nmiss, n, in another PROC MEAN I may use kurt std max min, and in some PROC MEAN, I may just need one or two specific variables)

So the macro cannot work in these case. But it is a very nice macro. I may adjust all the proc mean together to run the macro if there is no other solution.

Many thanks and warm regards.

Re: How to set the title quickly for proc means ?

SASKiwi — Tue, 09 Mar 2021 06:48:56 GMT

@Phil_NZ - You could enhance the macro to do different statistics by adding a stats parameter.

%macro Means (dataset = 
              ,stats_list = );

proc means data= &dataset &stats_list;
title "&dataset";
run;

%mend Means;

%Means (dataset = Have
        ,stats_list = mean min max);
%Means (dataset = Have2
        ,stats_list = n min max);

Re: How to set the title quickly for proc means ?

Phil_NZ — Tue, 09 Mar 2021 09:08:53 GMT

Hi @SASKiwi

Thank you for your insightful suggestion!

Warmest regards