Date:         Fri, 2 May 2008 17:37:58 -0400
Reply-To:     Sophia Tong <sophidt@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Sophia Tong <sophidt@HOTMAIL.COM>
Subject:      output data from PROC FREQ with formatted values

Dear listers,

I am trying to generate output data set from PROC FREQ with formatted
variables. the format name for each variable in a format of varF, i.e. if
variable name is AGEGRP then format name is AGRGRPF, so some format name
got more than 8 characters long.

I want output data set look like this:

AGEGRP PERCENT
<50      25%
50+      75%
INSURANCE PERCENT
Yes        65%
No         35%



Right now, my output data look like this:

AGEGRP PERCENT
<50      25%
50+      75%
INSURANCE PERCENT
1        65%
0        35%

I found this is because the format name for insurance is >8 long
(INSURANCEF).
Anyone know how to fix it?

Thanks,

Sophia