Date: Thu, 3 Jan 2008 11:03:29 -0500
Reply-To: Jake Bee <johbee@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Jake Bee <johbee@GMAIL.COM>
Subject: Re: Proc Import
Content-Type: text/plain; charset=ISO-8859-1
Just a guess, but you may have mixed types in the same column and may need
mixed = yes or change the spreadsheet.
PROC IMPORT OUT= test_import
On 1/3/08, Nishant Dholakia <email@example.com> wrote:
> Hello All,
> I am trying to use proc import to create a sas dataset from an excel
> sheet. The import takes place and the dataset is created however for one
> of the columns with values like
> 1 APP.
> 1 APPLICATION
> 1 DROP
> 20 MG
> All values get transferred to the sas dataset except for 0.01% or .10%
> I have no idea why this is happening. Has anyone been through something
> similar so that you can enlighten me.
> Thanks and Happy new year to all the SAS-L users.