Date:         Thu, 16 Nov 2006 13:30:05 +0100
Reply-To:     Stéphane COLAS <scolas@DATAMETRIC.FR>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Stéphane COLAS <scolas@DATAMETRIC.FR>
Subject:      Re: Using wildcards in IF statement??
Comments: To: salsera.77@HOTMAIL.COM
In-Reply-To:  <1163677460.171262.36190@k70g2000cwa.googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1

It works with a Alpha var. because '=:' is like a substr(var,1,?) => A BEGIN BY
statement, if you want.

So add quotes : IF SEL: = '11' and variable2=1;


Stéphane.

Selon salsera.77@HOTMAIL.COM:

> Dear SAS users,
>
> I've been trying to figure out a solution to a following problem:
>
> I know my data file contains a variable which begins with characteers
> SEL and I know that I can uniquely identify that variable ie. no other
> variables begin with those characters. I would like to extract
> observations that fill a certaing criterion in that variable and
> simultaniously another criterion in another variable. My first idea was
> to try to use colon wildcard
>
> IF SEL: = 11 and variable2=1;
>
> but this is not possible.
>
> Any ideas how I could come around this problem?
>
> Thanks,
>
> Mervi
>