| 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" <plummer@hsmgroup.com> wrote in message
news:mxDma.945$uT5.40499@news.uswest.net...
> 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
format.
> How can I input them as numeric instead?
>
> PROC IMPORT
> DATAFILE = 'C:\FILES\DATA.xls'
> OUT = sasdata
> DBMS = EXCEL
> REPLACE ;
> GETNAMES=YES ;
> RUN;
>
>
> Thanks,
> Brett
>
>
|
