Date: Thu, 13 Mar 2003 16:57:00 -0800
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
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
> 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.
David Cassell, CSC
Senior computing specialist