Date:         Wed, 14 Feb 2007 10:03:24 -0800
Reply-To:     Syb it <sas_datalover@YAHOO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Syb it <sas_datalover@YAHOO.COM>
Subject:      Re: Coding string/character vars
Comments: To: SAS_learner <proccontents@GMAIL.COM>
In-Reply-To:  <c2192a610702140951j31d8d91ah97eeeb501bec10e8@mail.gmail.com>
Content-Type: text/plain; charset=iso-8859-1

Dear List,

  Consider this scenario:

  Lets one wanted to code data this way

            Char Var

    Code
      Green
    Green only
    1
      GreenRed
    Green + Red
    2
      RedGreen
    Red + green
    2
      GreenYellow
    Green + Yellow
    3
      YellowGreen
    Yellow + Green
    3
      GreenRedAnycolor
    Red, Green + any color
    4
      AnycolorGreenRed
    Any color + Red, Green
    4
      Else
    The rest
    0


  data fieldgoal;
  set punt;
  if color = 'Green' then code =1;
  else if color in ('GreenRed','RedGreen') then code =2;
  else if color in ('GreenYellow','YellowGreen') then code =3;
  else if color in (‘___GreenREd’, ‘RedGreen__’) then code = 4;
  else code = 0;
  run;

  Note that Anycolor can be up to 20 other colors, therefore making those strings very different in spelling and in length. Does anyone have an idea how I can code this fourth one completely?

  thanks,

  Datalover Cantcode.


---------------------------------
We won't tell. Get more on shows you hate to love
(and love to hate): Yahoo! TV's Guilty Pleasures list.