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)" <suggest@sas.com>
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 RJF2@cdc.gov