Date:         Wed, 12 Mar 2003 16:16:35 +0100
Reply-To:     Peter Crawford <peter.crawford@DB.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Peter Crawford <peter.crawford@DB.COM>
Subject:      Re: Eliminating blank header cells in PROC TABULATE?
Comments: To: WIELKI Andre <wielki@INED.FR>
Content-type: text/plain; charset=iso-8859-1

if a datatstep is acceptable, then this _might_ be faster
filename a "c:\hamilt.htm";filename b "c:\hamilc.htm";
data _null_;
 infile a   lrecl=256; * 119 or 256 or larger ;
   file b   lrecl=256; * as large as neccessary;
 input;
     _infile_= tranwrd(  _infile_,     '&nbsp', ' ' );
/* use single, not double quotes around &nbsp .... */
 put _infile_;
run;



Datum:         12/03/2003 12:05
An:            SAS-L@LISTSERV.UGA.EDU




Antwort an:    WIELKI Andre <wielki@INED.FR>

Betreff:       Re: Eliminating blank header cells in PROC TABULATE?
Nachrichtentext:

Of course everything is possible in SAS   but sometimes longer (than with
ultraedit...)

filename a "c:\hamilt.htm";filename b "c:\hamilc.htm";
data _null_;infile a   lrecl=119;file b lrecl=119;
input ;line=_infile_;
pos=index(line,'nbsp');
if pos>0 then do; pos=pos-1;substr(line,pos,6)='';end;
put line $char119.;
run;
;

add on to previous answer

Andre



___________
WIELKI  Andre
INED - Service Informatique
133 Bd Davout,
75 980 Paris  Cedex 20
FRANCE
Tel: 01 56 06 21 54





--

Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet.

This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.