Date:         Sun, 3 Feb 2008 13:58:00 -0500
Reply-To:     Wensui Liu <liuwensui@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Wensui Liu <liuwensui@GMAIL.COM>
Subject:      Re: using sas to query an Excel spreadsheet?
Comments: To: RolandRB <rolandberry@hotmail.com>
In-Reply-To:  <511500d9-3a4f-4311-a9c8-17141515ac2b@y5g2000hsf.googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1

it is very easy. what you need to do is
1) define a named range in excel for the range you want to query
2) odbc to that named range, which you can write and read using proc
sql or data step.

On 2/3/08, RolandRB <rolandberry@hotmail.com> wrote:
> Is it possible from within sas to query an Excel spreadsheet to ask it
> which columns are being used and how many rows?
>


--
===============================
WenSui Liu
ChoicePoint Precision Marketing
Phone: 678-893-9457
Email : wensui.liu@choicepoint.com
Blog   : statcompute.spaces.live.com
===============================