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?
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 <email@example.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?
ChoicePoint Precision Marketing
Email : firstname.lastname@example.org
Blog : statcompute.spaces.live.com