Crystal:

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 [mailto:vierhout@unity.ncsu.edu] Sent: September 7, 2001 10:30 AM To: SAS-L@LISTSERV.UGA.EDU Subject: internet infile question

Hello,

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