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
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:
CREATE Table WANT1 AS
WHERE fac_id like '%01';
CREATE Table WANT2 AS
WHERE fac_id not like '%s%';
First dataset has only 01-01-01 observations, but the second data set has
Any assistance is appreciate.