Date:         Tue, 22 Nov 2011 09:00:59 -0800
Reply-To:     "Pardee, Roy" <pardee.r@GHC.ORG>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Pardee, Roy" <pardee.r@GHC.ORG>
Subject:      Re: MS open data access and SAS; web data retrieval
Comments: To: BJ Mattson <bj.mattson@ODH.OHIO.GOV>
In-Reply-To:  <201111221529.pAMBked9006807@waikiki.cc.uga.edu>
Content-Type: text/plain; charset="us-ascii"

There's also the HTTP and <<shudder>> SOAP procs.  And there's the javaobj stuff that might let you e.g., distribute java code that does the actual interfacing w/your web service & delivers the data to a SAS dstep.  See e.g., http://support.sas.com/rnd/base/datastep/dot/javaobj.html.

HTH,

-Roy

Roy Pardee | DATA WRANGLER
Group Health Research Institute

PHONE 360-447-8773 | 206-287-2078
E-MAIL pardee.r@ghc.org
www.grouphealthresearch.org
-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of BJ Mattson
Sent: Tuesday, November 22, 2011 7:29 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: MS open data access and SAS; web data retrieval

I haven't seen anything about ODATA posted in here, nor on support.sas.com, nor in the online doc, although my search may have been inadequate.

What we are looking for is a way for folks to connect to our internet server and be able to download the results of the query to the local PC.

I did see the Filename statement for URL access and if that is workable, would appreciate seeing some examples.

Other options and suggestions to research would be appreciated.

Thanks.

BJ

Group Health is people-powered: Join the conversation at: http://www.choosegrouphealth.org

GHC Confidentiality Statement

This message and any attached files might contain confidential information protected by federal and state law. The information is intended only for the use of the individual(s) or entities originally named as addressees. The improper disclosure of such information may be subject to civil or criminal penalties. If this message reached you in error, please contact the sender and destroy this message. Disclosing, copying, forwarding, or distributing the information by unauthorized individuals or entities is strictly prohibited by law.