Date:         Thu, 5 Feb 2009 13:37:57 -0500
Reply-To:     Kim Brown <kibrown@LADHS.ORG>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Kim Brown <kibrown@LADHS.ORG>
Subject:      Creating 2 Datasets with Wildcards
Content-Type: text/plain; charset=ISO-8859-1

Hello,

I’ve a data set that have two format for facility id (one format is 01-01-
01 and the other format is two digits (i.e. 20 or 60). I trying to create
two dataset based on this criterion.
Is there another wildcard I could use?

This is my syntax but it doesn’t work:
PROC SQL;
CREATE Table WANT1 AS
SELECT *
FROM HAVE
WHERE fac_id like '%01';

CREATE Table WANT2 AS
SELECT *
FROM HAVE
WHERE fac_id not like '%s%';
QUIT;

First dataset has only 01-01-01 observations, but the second data set has
all records.
Any assistance is appreciate.
thanks, kim