Date:         Wed, 12 May 2010 19:57:08 -0700
Reply-To:     "Choate, Paul@DDS" <Paul.Choate@DDS.CA.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Choate, Paul@DDS" <Paul.Choate@DDS.CA.GOV>
Subject:      Re: Data import from Excel
In-Reply-To:  <201005122324.o4CL61WU019026@malibu.cc.uga.edu>
Content-Type: text/plain; charset="us-ascii"

or use DDE SAVE.AS text and OPEN.


SAVE.AS

SAVE.AS(document_text, type_num, prot_pwd, backup, write_res_pwd, read_only_rec)

Document_text specifies the name of a workbook to save, such as SALES.XLS. You can include a full path in document_text, such as C:\EXCEL\ANALYZE.XLS

Type_num   File format
3                  Text


OPEN

Equivalent to choosing the Open command from the File menu. Opens an existing workbook.

OPEN(file_text, update_links, read_only, format, prot_pwd, write_res_pwd, ignore_rorec, file_origin, custom_delimit, add_logical, editable, file_access, notify_logical, converter)

File_text    is the name, as text, of the workbook you want to open. File_text can include a drive and path, and can be a network pathname. File_text can include an asterisk (*) to represent any sequence of characters and a question mark (?) to represent any single character.

hth - PC
________________________________________
From: SAS(r) Discussion [SAS-L@LISTSERV.UGA.EDU] On Behalf Of r.hockey@SPH.UQ.EDU.AU [r.hockey@SPH.UQ.EDU.AU]
Sent: Wednesday, May 12, 2010 4:24 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: Data import from Excel

On Wed, 12 May 2010 16:50:25 -0500, Joe Matise <snoopy369@GMAIL.COM> wrote:

The easiest way to fix the problem in Excel is to select the column
containing the dates and using Data->text-to-columns (just follow the
prompts) and select date as the data type.
This method can fix a lot of problems when importing Excel data.
R

>You can use the DATEVALUE() function, that's probably fastest, or use a VB
>macro.
>
>-Joe
>
>On Wed, May 12, 2010 at 4:42 PM, Mark S. <marksmolkin@gmail.com> wrote:
>
>> yep. it doesn't convert to a number when I re-format. Any idea whether
>> there
>> is a quick way to convert an entire block of these values instead of going
>> cell by cell?
>>
>> Mark
>>