|Date: ||Tue, 29 Apr 2003 10:23:16 -0400|
|Reply-To: ||Kevin <kterry@ATT.COM>|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||Kevin <kterry@ATT.COM>|
|Organization: ||ITS - NetNews|
|Subject: ||Re: Importing Excel data into SAS|
The easiest way to fix this problem would be to save the .xls file as a .csv
and read it into SAS in a general infile statemtent where you can contol the
format of the variables.
"Brett Plummer" <email@example.com> wrote in message
> In Excel, the variables are in number format and not text. But when using
> the code below, all of the variables are brought into SAS in STRING
> How can I input them as numeric instead?
> PROC IMPORT
> DATAFILE = 'C:\FILES\DATA.xls'
> OUT = sasdata
> DBMS = EXCEL
> REPLACE ;
> GETNAMES=YES ;