Date: Thu, 25 May 2000 14:25:12 -0500
Reply-To: Phil Rhodes <Phillip_Rhodes@BAYLOR.EDU>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Phil Rhodes <Phillip_Rhodes@BAYLOR.EDU>
Subject: Re: Proc Access - Excel to SAS creates missing values???
Content-Type: text/plain; charset="us-ascii"; format=flowed
At 02:05 PM 5/25/00, Automatic digest processor wrote:
>I tried proc access to create a SAS dataset from Excel, but am
>getting missing values for icd-9 codes. The problem (I think) is
>that the field looks like it has numeric and character values but
>it is really supposed to be character in SAS. Any suggestions??
I've had this problem as well. Try setting the following options
on PROC ACCESS:
IIRC, the MIXED option is the key one.
Institutional Research and Testing