topic Re: Show All Ranges of Proc Format in Proc Freq in SAS Programming

Show All Ranges of Proc Format in Proc Freq

sasmaverick — Wed, 07 Jun 2017 12:41:21 GMT

Hi,

I am associating a user defined format with a variable and generating a freq report. I want to see all values of proc format in the report, even though they may not be in the dataset. Below is an example.

proc format;
value test
.='Missing'
low-<0='<0'
1-5='1-5'
6-10='6-10'
11-15='11-15'
16-high='15+'
;
run;

data test;
infile datalines;
input a;
datalines;
.
-1
5
7
18
;
run;

proc freq data=test;
tables a/list missing sparse;
format a test.;
run;

The resulting report does not show the 11-15 range since it is not in the dataset. I want to show missing for 11-15.

Help appreciated.

Re: Show All Ranges of Proc Format in Proc Freq

Reeza — Wed, 07 Jun 2017 13:14:53 GMT

PRELOOADFMT is the option your looking for, in combination with PROC TABULATE.

Proc tabulate data = have;
Class a / preloadfmt missing;
Format a test.;
Table a;
Run;

Re: Show All Ranges of Proc Format in Proc Freq

sasmaverick — Wed, 07 Jun 2017 14:52:07 GMT

This doesn't give me percentages.

##- Please type your reply above this line. Simple formatting, no
attachments. -##

Re: Show All Ranges of Proc Format in Proc Freq

ballardw — Wed, 07 Jun 2017 15:45:05 GMT

Tabulate has several percentage calculators available. You might try

Proc tabulate data = have;
Class a / preloadfmt missing;
Format a test.;
Table a,

n pctn;
Run;

Re: Show All Ranges of Proc Format in Proc Freq

sasmaverick — Wed, 07 Jun 2017 15:47:28 GMT

Are you sure this is working. I still don't see 11-15 range in the report.

##- Please type your reply above this line. Simple formatting, no
attachments. -##

Re: Show All Ranges of Proc Format in Proc Freq

Reeza — Wed, 07 Jun 2017 16:39:39 GMT

Try adding the PRINTMISS option after the TABLE statement.

See the example in the docs:

http://support.sas.com/documentation/cdl/en/proc/65145/HTML/default/viewer.htm#p1f1t9bipbeqy5n1vowhzzk3vuby.htm