topic Re: Proc freq into excel - layout and design in SAS Programming

Proc freq into excel - layout and design

mmea — Wed, 21 Oct 2020 11:50:12 GMT

I want to style my proc freq plot just as this.

is that possible

Re: Proc freq into excel - layout and design

PaigeMiller — Wed, 21 Oct 2020 12:26:39 GMT

It would be fairly simple to do the formatting in Excel rather than in SAS. This type of formatting can be done in SAS but it takes more effort, and I would do it in PROC REPORT rather than PROC FREQ.

If this is something that has to be automated, then I guess you would want to do it in SAS. Here are some examples: https://support.sas.com/resources/papers/proceedings14/SAS388-2014.pdf but there are a gazillion (well, actually a gazillion minus 7 🤣) papers out there on the internet on how to get this type of formatting from PROC REPORT.

Re: Proc freq into excel - layout and design

Reeza — Wed, 21 Oct 2020 15:02:51 GMT

Depends on how exact you want to get. You can get exactly that but it requires some work to get it formatted exactly.

You have a couple of options:

Use a style that's close enough and call that a day
Develop your entire own style template - if you're a company and will be doing a lot of regular reporting this can definitely be worth the time investment.
Use PROC REPORT and customize the output to match what's shown below. Here's a rough idea, you'll need to customize your

proc report data=sashelp.cars(obs=10) style(header)=[background=cx2b8cbe foreground=black] ;
column origin make model type mpg_city mpg_highway;
   compute type;
      count+1;
      if not(mod(count,2))  then do;
         call define(_row_, "style", "style=[background=lightgrey]");
      end;
   endcomp;
run;

https://support.sas.com/kb/23/647.html

(modified)

@mmea wrote:

Hi

I want to style my proc freq plot just as this.

is that possible