LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (March 1997, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Mon, 17 Mar 1997 11:33:00 PST
Reply-To:     "Dann, Alec" <DannA@WASHPOST.COM>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         "Dann, Alec" <DannA@WASHPOST.COM>
Subject:      FW: Macrovariable "in( <list>)" comparison method?

Seems you already have the answer. Why not try:

trim(left("&x")) in( 'value1', 'value2',..., 'valuen' )

Code above assumes case is not an issue and that 'value1' - 'valuen' have no leading or trailing blanks.

Alec Dann danna@washpost.com

---------- From: owner-sas-l[SMTP:owner-sas-l@VM.MARIST.EDU] Sent: Saturday, March 15, 1997 6:40 AM To: SAS-L Subject: Macrovariable "in( <list>)" comparison method?

<c=US%a=_PM2%p=PM2%l=PM2_SERVER1-970315143958Z-686@PM2_SERVER1.pmsquared. com> X-LSVTag: From: Karsten Self <kmself@pmsquared.com> X-LSVTag: To: 'sas-l' <sas-l@uga.cc.uga.edu> X-LSVTag: Subject: Macrovariable "in( <list>)" comparison method? X-LSVTag: Date: Sat, 15 Mar 1997 06:39:58 -0800 X-LSVTag: Return-Receipt-To: <kmself@pmsquared.com> X-LSVTag: X-Mailer: Microsoft Exchange Server Internet Mail Connector Version 4.0.994.57 X-LSVTag: MIME-Version: 1.0 X-LSVTag: Content-Type: text/plain; charset="us-ascii" X-LSVTag: Content-Transfer-Encoding: 7bit To: $PEER$ <SAS-L@VTVM1.CC.VT.EDU>

From the "there's got to be a better way" department:

Would either of you SAS-L types who aren't already at or en-route to San Diego have, and would you be willing to share, a slick way of testing a macrovariable value against several possible matches -- the equivalent of:

x in( 'value1', 'value2',..., 'valuen' )

...in the good ole' data step.

Muchos gracias.


Back to: Top of message | Previous page | Main SAS-L page