topic Re: [SAS note] Import excel - V9 issue in SAS Programming

[SAS note] Import excel - V9 issue

Winkle — Thu, 20 Sep 2018 17:19:36 GMT

Hi All,

May I consult one issue regard to excel file import? Our SAS version is SAS 9.4 EG.

When I import excel file (.xlsx & .xls), will have one log issue as follows,

NOTE: One or more variables were converted because the data type is not supported by the V9 engine. For more details, run with options MSGLEVEL=I.

(Program:

PROC IMPORT DATAFILE="&_project.data\sdtm csv\test.xlsx" OUT=temp1 DBMS= xlsx replace; Sheet = "TA";getnames = Yes;
RUN;)

Could you please let me know how to solve this issue?

Thank you so much 🙂

ballardw — Thu, 20 Sep 2018 17:46:34 GMT

Did you run the code after setting msglevel=1?

This is a data content issue. Without seeing actual data that might be very hard to diagnose.

Did the sheet contain any graphs or pivot tables? Those are possible issues.

I would suggest looking at the data in the resulting SAS data set and examining the Excel file to see what did not end up in the SAS data set.

himself — Wed, 24 Feb 2021 12:06:58 GMT

Hi, I know the reply is out of date, but i did put options msglevel=I and the bad note was no more.