topic Re: Freq Report Customization in SAS Programming

Freq Report Customization

Yen — Thu, 16 Jun 2016 20:59:13 GMT

data test;

input desc $;

datalines;

;

run;

proc freq data=test;

tables desc;

run;

Have:

desc Frequency Percent Cumulative
Frequency Cumulative
Percent

Want:

Astounding — Thu, 16 Jun 2016 21:41:01 GMT

There are going to be ways to do this in one step, but the two-step version is easy to understand:

proc freq data=test;

tables desc / noprint out=counts;

run;

proc tabulate data=counts;

class desc;

var count;

tables count, desc=' '*sum=' ';

title 'Summary';

run;