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 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Fri, 7 Sep 2001 10:39:53 -0400
Reply-To:   "Droogendyk, Harry" <Harry.Droogendyk@CIBC.COM>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   "Droogendyk, Harry" <Harry.Droogendyk@CIBC.COM>
Subject:   Re: internet infile question
Content-Type:   text/plain; charset="iso-8859-1"


You can bury macro variables right in the HTML. When inputing the HTML file check for the presence of the ampersand, if found use the RESOLVE function to obtain the value of the macro variable:

data _null_; infile test; file _webout; input; if index(_infile_,'&') > 0 then _infile_ = resolve(_infile_); put _infile_; run;

Note that you will get unresolved messages if your HTML contains any HTML pneumonics, e.g. &nbsp. You can always define those to your SAS program ( e.g. %let nbsp = %nrstr(&nbsp); ) to keep the warnings out of the log.

Regards, Harry

-----Original Message----- From: Crystal Vierhout [] Sent: September 7, 2001 10:30 AM To: SAS-L@LISTSERV.UGA.EDU Subject: internet infile question


With SAS/Intrnet I have used and infile statement to pull HTML code in. What is the best way to handle large amounts of html code if you want to macro within the infile code? Is htmSQL a high recommendation or is there another way? Is the only using large amounts of puts?

data _null_;

infile test ;

file _webout;

input ;

put _infile_;

Crystal Vierhout Dairy Records Management Systems

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