Thanks Richard, Yeah, that's a better way of saying it. I was trying to answer the question of getting it to show in the %put, and a space is all you'll see. Thanks for elaborating better. Mark

-----Original Message----- From: Richard DeVenezia [mailto:radevenz@IX.NETCOM.COM] Sent: Friday, March 30, 2001 11:45 AM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: Hex value for line feed

Mark:

Acutally, SQL will let you used non-printables as separators. Try ... separated by '0A'x ... data _null_; a = "&namelist"; r = rank (substr(a,5,1)); put r=; run;

You will see R=10 in the log

The thing is, %put is NOT going to put a newline in the log, just the internal printable substitute that the macro system uses for non-printables (in this case it's a space)

-- Richard DeVenezia - SAS Macros and AF Tools http://www.devenezia.com

"Terjeson, Mark" <TerjeMW@DSHS.WA.GOV> wrote in message news:B0562E2B5957D411A42800D0B782284003F4C52D@dshsmsgf1-a.dshs.wa.gov... > Hi Wei, > > > data mydata; > name = 'Fred ';output; > name = 'Wilma ';output; > name = 'Barney ';output; > name = 'Betty ';output; > name = 'Pebbles';output; > name = 'BamBam ';output; > name = 'dino ';output; > run; > > > * the carraige-return, line-feed ; > * are decimal 13,10 or hex 0d,0a ; > > * but the macro variable is not going ; > * to let you have non-printable chars ; > * in the SEPARATED BY ; > > proc sql noprint; > select name into :namelist separated by ' ' > from mydata; > quit; > %put namelist is >&namelist<; > > > * how about ; > data _null_; > set mydata; > put name; > run; > > * or how about ; > data _null_; > stmp = trim(left("&namelist")); > wordcount = length(stmp) - length(compress(stmp)) + 1; > do i = 1 to wordcount; > name = scan(stmp,i); > put name; > end; > run; > > > Hope this is helpful, > Mark Terjeson > Washington State Department of Social and Health Services > Division of Research and Data Analysis (RDA) > mailto:terjemw@dshs.wa.gov > > > > -----Original Message----- > From: wei cheng [mailto:cheng_wei@HOTMAIL.COM] > Sent: Thursday, March 29, 2001 11:27 AM > To: SAS-L@LISTSERV.UGA.EDU > Subject: Hex value for line feed > > > If I create a macro variable from PROC SQL; SELECT INTO clause. For example: > > Proc sql noprint; > select name into :namelist seperated by ' ' > from mydata; > quit; > > Then I need to put the &name to the log: > > %put &namelist; > > The Log will shows the name list in one line seperated by a blank. If I need > different name shows in different line, I think that I need to use the hex > value of line feed to seperate the names when generating the &namelist. I > used to have Ultraedit that I can check the hex value there, but I don't > have the Ultraedit any more. > > Can any one provides me the Hex value for the line feed? > > Or if you have some better methods to achieve that? > > TIA, > > > > > > Wei Cheng > ================================================================= > http://www.geocities.com/prochelp > INTERNET and Web Resources for SAS Programmers and Statisticians > ================================================================= > > _________________________________________________________________ > Get your FREE download of MSN Explorer at http://explorer.msn.com