topic Re: Changing the display of Proc Freq in SAS Procedures

Changing the display of Proc Freq

jacob_klimek — Thu, 24 Sep 2015 18:51:46 GMT

So I am trying to do a proc freq for data that looks like this

id_num race

xxx 1

xxx 2

xxx 3

xxx 4

So when I do proc freq on race I want to the display to show actual races instead of 1,2,3,4 like white, black, asian, hispanic.

I have tried a few things (replacing values but that didn't work at all) but can't get anything close so all I really have is.

proc freq data=test;

tables race;

title;

footnote;

run;

which brings up

Race Code RACE Frequency Percent Cumulative
Frequency Cumulative
Percent

but I

ballardw — Thu, 24 Sep 2015 19:25:36 GMT

What you are looking for is a format.

You define the values with proc format:

Proc format;

value race

1='White'

2='Black'

3='Native American'

/* continue as needed*/

;

run;

Use by

proc freq data=test;

tables race;

format race race.;

run;

Note: the FORMAT reference ends in a period to tell SAS that it is a format not a variable.

evp000 — Thu, 24 Sep 2015 19:27:14 GMT

Hi,

Using a format should produce the results you want:

/* create the format */

proc format;
value racefmt
1 = 'white'
2 = 'black'
3 = 'asian'
4 = 'hispanic';
run;

/* source data */

data test;
length id_num $5 race 8.;
input id_num race;
datalines;
aaa 1
bbb 2
ccc 3
ddd 4
;

/* display using format */

proc freq data = test ;
tables race ;
format race racefmt.;
run;