|
I'll ditto that Ron! I vote.
Mark
PS: They also need to fix the array version of
INTO: to trim the trailing spaces. The TRIM
and NOTRIM have no effect, and using trim()
also has no effect. Non-multiple vars of INTO:
get trimmed fine.
-----Original Message-----
From: Fehd, Ronald J. [mailto:rjf2@CDC.GOV]
Sent: Tuesday, September 18, 2001 2:09 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: macro language enhancement
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
| 
