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 2001, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Tue, 18 Sep 2001 17:08:35 -0400
Reply-To:     "Fehd, Ronald J." <rjf2@CDC.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Fehd, Ronald J." <rjf2@CDC.GOV>
Subject:      macro language enhancement
Comments: To: "SAS Suggest@sas. com (E-mail)" <>
Content-Type: text/plain; charset="iso-8859-1"

in the select clause allow a CR/LF == CarriageReturn+LineFeed as argument to the separated by clause.

This will facilitate reading and proofreading of long macro variables created by the into :<macro-variable-name> clause.

example: proc SQL noprint; select trim(MemName) into :LIST separated by " " from DICTIONARY.TABLES where MemType = "DATA" and LibName = "LIBRARY" ;quit; %PUT LIST<&LIST.>; This produces a looooong line, which is hard to read, since it runs past the viewable edge of the screen.

result: 845 %PUT LIST<&LIST.>; LIST<FMT0002 FMT0008 FMT0102 FMT9706 FMT9802 FMT9806 FMT9902 FMT9908 FORMATS


if we have some special character: separated by "<name of automagic CR/LF>" then the desired result might be:

845 %PUT LIST<&LIST.>; LIST<FMT0002 FMT0008 FMT0102 FMT9706 ...>

vertically long, but neverthless, easier to comprehend

Ron Fehd the macro maven CDC Atlanta GA USA

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