Hi
I want to style my proc freq plot just as this.
is that possible
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.
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:
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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.