Date:         Fri, 28 Aug 2009 06:06:29 -0700
Reply-To:     "Richard A. DeVenezia" <rdevenezia@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Richard A. DeVenezia" <rdevenezia@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: Ignoring Case
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

On Aug 27, 3:42 pm, jas...@UCLA.EDU (J M) wrote:
> I have a variable lvl1 which is comprised of uppercase names (eg APPLE, PEAR).
> Is there a way to ignore case and find "apple" without taking case
> into consideration (eg "Apple","apple","aPPle",etc) in the following
> situation:
> proc freq data=test;
> table x;
> where lvl1 in ("aPple");
> run;

Jason:

You can use the session wide setting CAPS to force uppercase
processing.

  data one;
  a='Hello'; output;
  a='hello'; output;
  run;

  options caps=on;

  data two;
    set one;
    where a='hello';
  run;

  ods listing;

  proc freq data=one;
    table a;
  run;

  options caps=off;

--
Richard A. DeVenezia
http://www.devenezia.com