topic Re: How to capture all categories in PROC FREQ in SAS Programming

How to capture all categories in PROC FREQ

GRP_Canada — Mon, 24 Feb 2020 16:26:46 GMT

Hi...

I have been using PROC FREQ as part of data validation (SAS EG7). However, as samples of all my variable splits are not always present my output will typically have lines omitted. As a result, I have to manually adjust in Excel to capture any missing outcomes

I am looking for a solution which will show ALL of the variable outcomes regardless if there was data present or not

thanks!

proc freq data= temp_sas;

table risk_calc * score /nopercent nocol nocum norow missing;

run;

The full list of outcomes for the variables should be:

- risk_calc (which is derived based on the product, length of time as customer, scores, etc..)

'A.1EMN1','A.2EMN2','A.3EMN3','A.4EYN1','A.5EYN2','A.6EYN3','A.7ENN3'

- score:

'000-164','165-169','170-194','195-199','200-204','205-209','210-219','220-224','225-229',

'230-234','235-239','240-244','245-249','250-269','270+'

Re: How to capture all categories in PROC FREQ

PaigeMiller — Mon, 24 Feb 2020 16:36:10 GMT

With PROC MEANS and PROC REPORT and PROC TABULATE, you can use the PRELOADFMT option. I don't know if it works with PROC FREQ. Here is an example using PROC MEANS: https://documentation.sas.com/?docsetId=proc&docsetTarget=n1eseaucwkzo18n1nph31op5kkdt.htm&docsetVersion=9.4&locale=en#n1eseaucwkzo18n1nph31op5kkdt

Re: How to capture all categories in PROC FREQ

GRP_Canada — Mon, 24 Feb 2020 17:40:46 GMT

Good suggestion - I switched over to PROC TABULATE and added PRELOADFMT - looks good!

Thanks!

Re: How to capture all categories in PROC FREQ

Ksharp — Tue, 25 Feb 2020 05:15:21 GMT

data levels;
input sex $;
cards;
F
M
N
;

data have;
 set sashelp.class(in=ina) levels;
 w=ina;
run;
proc freq data=have;
table sex/norow nocol nocum nopercent missing missprint; 
weight w/zeros;
run;