Date:         Wed, 21 Jul 2010 09:35:39 -0400
Reply-To:     Jonas Bilenas <jonas.bilenas@CHASE.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Jonas Bilenas <jonas.bilenas@CHASE.COM>
Subject:      Re: Aaargh fomat/informat :-(

It is easier if you show your code, but this looks simple enough.  Try
playing with this:

proc format;
  value $sex 'M', 'm' = 'Male'
             'F', 'f' = 'Female'
             other    = [$1.]
  ;
run;

proc freq data=YOUR_DATA;
  table sex;
  format sex $sex.;
run;


For more help and a shameless plug, check out my SAS Press book; The Power
of Proc Format,

Jonas Bilenas

On Wed, 21 Jul 2010 06:54:06 +0000, Laughing Beggar
<laughing_beggar@HOTMAIL.COM> wrote:

>Hi all,
>I have a character variable called sex that is variously coded 'M' or 'm'
or 'F' or 'f' and I want it to appear in a Proc Freq table as 'Male'
and 'Female'.
>I thought I'd try doing it with a format or an informat but have fully
failed.
>Can it be done this way?
>Cheers
>L_B
>
>"The beggar laughs in the face of the thief"
>
>
>_________________________________________________________________
>Browse profiles for FREE! Meet local singles online.
>http://clk.atdmt.com/NMN/go/150855801/direct/01/