Date:         Fri, 17 May 2002 10:06:17 +0100
Reply-To:     david.mcnulty@QUESTINTL.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         david.mcnulty@QUESTINTL.COM
Subject:      Re: PROC IMPORT - Excel
Comments: To: "Manktelow, B." <bm18@LEICESTER.AC.UK>
Content-type: text/plain; charset=us-ascii

Hello Brad,

I've missed most of this thread so don't know what has gone before.

The alternative to Proc Import is Proc Access. Both Proc Access and Proc
DBLoad (equivalent to Proc Export) were initially released for Excel 5
files. I belive there is an upgrade to support Excel 97 files but no
support for Excel 2000 files. (Its a long time since I was on the SAS
site.)

If Proc Access is of no help try the following fix.
Proc Import uses the first few records to define the format of each column.
In my case we have lots of missing values. To ensure Proc Import uses the
correct input data type and format we insert a dummy first record with the
correct data types and formats.

Finally I am reliably informed you could try DDE - I have never used it
myself.

Dave.




                    "Manktelow,
                    B."                   To:     SAS-L@LISTSERV.UGA.EDU
                    <bm18@LEICESTE        cc:     (bcc: David Mcnulty/GB/QUES/ICI)
                    R.AC.UK>              Subject:     Re: PROC IMPORT - Excel
                    Sent by:
                    "SAS(r)
                    Discussion"
                    <SAS-L@LISTSER
                    V.UGA.EDU>


                    16/05/2002
                    12:44
                    Please respond
                    to "Manktelow,
                    B."






Thanks to Curtis, Ian and Hamani for their replies to my query.

We are going through the variables to see if there is a recognisable cause
to our difficulties, as we are curious to know what is going on.  In the
meantime we will load the data specifying the informat and format
statements.

Just as a further question it was suggested to use PROC IMPORT.  I have
always assumed that the IMPORT WIZARD just used PROC IMPORT, with default
settings, allowing me to be lazy and not have to remember the syntax.  Is
this the case or are they different?

Many thanks once again,

Brad
_____________________________________________

Brad Manktelow
Research Fellow in Medical Statistics
Department of Epidemiology and Public Health
University of Leicester
22-28 Princess Road West
Leicester LE1 6TP

e-mail: bm18@le.ac.uk



IMPORTANT NOTICE:
This email is confidential, may be legally privileged, and is for the
intended recipient only.  Access, disclosure, copying, distribution, or
reliance on any of it by anyone else is prohibited and may be a criminal
offence.  Please delete if obtained in error and email confirmation to the
sender.