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 (September 2004, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Tue, 7 Sep 2004 17:18:18 -0400
Reply-To:     sashole@bellsouth.net
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Paul M. Dorfman" <sashole@BELLSOUTH.NET>
Organization: Sashole of Florida
Subject:      Re: Double Duty for % Sign
Comments: To: Talbot Michael Katz <topkatz@MSN.COM>
In-Reply-To:  <200409072058.i87KwdQ1029825@listserv.cc.uga.edu>
Content-Type: text/plain; charset="us-ascii"

TMK,

If you *must* use the double quotes (or, optionally, no quotes at all) because, for instance, of other macro references you might actually want to resolve, replace % with %str(%), leaving everything else intact.

Kind regards, ---------------- Paul M. Dorfman Jacksonville, FL ----------------

> -----Original Message----- > From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On > Behalf Of Talbot Michael Katz > Sent: Tuesday, September 07, 2004 4:59 PM > To: SAS-L@LISTSERV.UGA.EDU > Subject: Double Duty for % Sign > > Hi. > > This question probably has arisen before. Here is a portion > of my log from a print request that worked perfectly as > desired, but generated warnings. > My question is, is there a way to do this without generating warnings? > > 125 title3 "local print > SFD.SO04_S22_USE03_fuMOFI2_cont_1 (where > = (upcase(name) like > 125! %_2005))" ; > WARNING: Apparent invocation of macro _2005 not resolved. > 126 proc print data = SFD.SO04_S22_USE03_fuMOFI2_cont_1 > (where = (upcase(name) > 126! like "%_2005")) noobs ; > WARNING: Apparent invocation of macro _2005 not resolved. > 127 var name ; > 128 run ; > > NOTE: There were 38 observations read from the data set > SFD.SO04_S22_USE03_FUMOFI2_CONT_1. > WHERE UPCASE(name) like '%_2005'; > NOTE: PROCEDURE PRINT used: > real time 0.00 seconds > cpu time 0.00 seconds > > Thanks! > > -- TMK -- >


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