Date:         Wed, 7 Jun 2000 13:42:17 -0700
Reply-To:     "Terjeson, Mark" <TERJEMW@DSHS.WA.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Terjeson, Mark" <TERJEMW@DSHS.WA.GOV>
Subject:      FW: IMPORT - Excel(date) to V6.12(date) vs V8.00(datetime)
Content-Type: text/plain

Hi gang,
    After a couple good comments I think maybe
I can further arrange the characteristics of my
question.  I guess this revised question is more
along the lines of "any discussion" or "confirming
experience".......
    Something I didn't mention the first time is that
we all know that the import routines (underneath)
have been implemented differently between 6.12
and 8.00.(or the different format version levels)
    But now to continue on:   doing a couple of
further tests,  the behavior of Excel(date) to SAS(*date*)
seems to be associated with import conversion type
"Microsoft Excel 5 or 7 Spreadsheet" regardless of
V6.12 or V8.00 and  Excel(date) to SAS(**datetime**)
seems to be associated with import conversion type
"Microsoft Excel 97 or 2000 Spreadsheet".
    So I guess the difference is not between SAS versions
but between import-format-flavor(format version level routines).

Am I on a more accurate/consistent track?
Anyone concur?
Mark Terjeson
Washington State Department of Social and Health Services
Division of Research and Data Analysis (RDA)
(360) 902-0741
(360) 902-0705 fax
mailto:terjemw@dshs.wa.gov





> -----Original Message-----
> From: Terjeson, Mark [SMTP:TERJEMW@DSHS.WA.GOV]
> Sent: Wednesday, June 07, 2000 11:33 AM
> To:   SAS-L@LISTSERV.UGA.EDU
> Subject:      IMPORT - Excel(date) to V6.12(date) vs V8.00(datetime)
>
> IMPORT - Excel(date) to V6.12(date) vs V8.00(datetime)
>
> Is this really a difference between versions?
> or is there a setting somewhere to flip the outcome?
>
> i.e.  Using the IMPORT wizard to load an Excel
> spreadsheet with an Excel DATE in a column,
> the resulting column in V6.12 is a DATE, and
> the resulting column in V8.00 is a DATETIME.
>
> Is there an option(s) anywhere that can tell V8
> to convert an Excel(date) to SAS(date) instead
> of SAS(datetime)?
>
> Maybe I've missed this topic if it was on sas-l
> previously, but let me know what IMPORT
> alternatives there might be.  Obviously, a
> subsequent use of DATEPART() can convert it
> after the fact, but I was wondering if there was
> anything related "during" the IMPORT phase.
>
> Mark Terjeson
> Washington State Department of Social and Health Services
> Division of Research and Data Analysis (RDA)
> (360) 902-0741
> (360) 902-0705 fax
> mailto:terjemw@dshs.wa.gov