topic Re: Proc Import excel file with decimal values in SAS Programming

Proc Import excel file with decimal values

David_Billa — Fri, 10 Jul 2020 07:50:49 GMT

I'm trying to Import below data from .xls file, but after the Import one of the value is not imported correctly as it was in the file.

Could you please help me understand why the value 0,0086419468 is truncated to 0,0086419 after Import? I was adivised to use only proc Import, so looking for a solution in the same.

Value

0,4722918040
0,0086419468

After Import, I got the data as

Value

0,472291804
0,0086419

Code which I used is,

PROC IMPORT OUT= WORK_OUTPUT1
     DATAFILE= EXCEL_INPUT
     DBMS=xls REPLACE;
     SHEET=SHEET; 
     GETNAMES=NO;
     MIXED=YES;
RUN;

Re: Proc Import excel file with decimal values

Patrick — Fri, 10 Jul 2020 07:54:34 GMT

I'd be adding guessingrows=max

Is the actual value truncated or is it just a display issue. Have you tried printing with format 32. ?

Re: Proc Import excel file with decimal values

David_Billa — Fri, 10 Jul 2020 07:59:54 GMT

Actual value is truncated.
Any idea why I see the issue one of the row instead of all rows?

Re: Proc Import excel file with decimal values

Patrick — Fri, 10 Jul 2020 08:01:22 GMT

Try with guessingrows=max first please.

Re: Proc Import excel file with decimal values

David_Billa — Fri, 10 Jul 2020 08:10:54 GMT

@Patrick I think guessingrows will work when proc import csv but not excel. I need to import excel file with multiple sheet.

Re: Proc Import excel file with decimal values

Patrick — Fri, 10 Jul 2020 08:18:00 GMT

@David_Billa Yes, you're right. Then I don't know. If it's a one-off then I'd just save the file as XLSX and import this one.