Date:         Thu, 26 Dec 1996 16:42:57 -0600
Reply-To:     "Kevin F. Spratt" <Kevin-Spratt@UIOWA.EDU>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         "Kevin F. Spratt" <Kevin-Spratt@UIOWA.EDU>
Subject:      Re: Proc Access
Comments: To: "Jim Carter, SCT Corporation" <JCARTER@sctcorp.com>
Content-Type: text/plain; charset="us-ascii"

At 04:17 PM 12/26/96 -0500, you wrote:
>Sorry Kevin, meant to provide more detail...
>
>On page 8-14 of the SAS Access For PC File Formats manual, it lists the
>GETNAMES option.  If it's set to "Y", then SAS will grab the var name from
>the first line.  YOu can also use the SKIPROWS option to tell it to skip
>over >1 line too...  By default, it GETNAMES is set to Y, then SKIPROWS is
>set to 1.
>
>So, it would look something like:
>
>       PROC ACCESS DBMS=XLS;
>           CREATE WORK.MYVIEW.ACCESS/VIEW;
>           GETNAMES=Y;
>        RUN;
>
>Hope this helps,
>
>Jim C.
>
>
Thank-you for the assist.  I figured out which manual you were referring to
and, low and behold,
there is the documentation.  GETNAME is not in the online help, and I was
looking at a previous
version of the SAS Access for PC File Formats, which did not include this
item.
 
I implemented your suggestion and it worked just as I needed.  Thank you
very much.
 
___________________________________________________________
 
Kevin F. Spratt
Iowa Testing Programs &
Spine Diagnostic & Treatment Center
224-C Lindquist Center
University of Iowa
Iowa City, Iowa  52242
(319) 335-5572         (voice)
(319) 335-6399         (fax)
Kevin-Spratt@Uiowa.edu (e-mail)