MSGLEVEL=I

geneshackman — Fri, 05 Feb 2021 14:37:28 GMT

i'm reading in an excel file

PROC IMPORT DATAFILE= "\\folder\pa54.xlsx"
out=pa54_working dbms=xlsx replace;
sheet='Sheet3';
RUN;

and i get this

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.

Where, exactly, do I put in options MSGLEVEL=I? I looked through 3 web search pages and can't find it.

i tried this line alone

options msglevel=1;

and got

ERROR 14-12: Invalid option value 1 for SAS option MSGLEVEL

Re: MSGLEVEL=I

KathyKiraly — Fri, 05 Feb 2021 14:48:15 GMT

The value for the MSGLEVEL system option is the letter I, not the number one.

options msglevel=i;

geneshackman — Fri, 05 Feb 2021 14:53:36 GMT

That worked. Thank you very much.