Date:         Thu, 13 Mar 2003 16:57:00 -0800
Reply-To:     cassell.david@EPAMAIL.EPA.GOV
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "David L. Cassell" <cassell.david@EPAMAIL.EPA.GOV>
Subject:      Re: Is it possible to read the results if a web query into a SAS
              dataset?
Content-type: text/plain; charset=us-ascii

Matt Flynn <matt.flynn@THEHARTFORD.COM> wrote:
> Is it possible to read the results if a web query into a SAS dataset?
>
> I can read static web pages easily with a "filename url" command. But
I am
> a bit stumped on how to read dynamically generated pages.
>
> In M$ Excel, as web query (.igy) to a ASP generated page returns data
> handily.  Has anyone examples, tips, or suggestions to share on how to
> accomplish this with SAS?

I suggest you use an intermediate program to snag the webpage, and then
pipe that into SAS.  You could use webget, or lynx (a web browser with a
command-line interface).  I prefer Perl.  Try using the LWP::Simple
module to snag the webpage.  If that isn't enough support, check out
the LWP::UserAgent module instead.

HTH,
David
--
David Cassell, CSC
Cassell.David@epa.gov
Senior computing specialist
mathematical statistician