msg_level optionin ods excel

xxformat_com — Sat, 30 Oct 2021 09:56:14 GMT

Hi,

Updated post (old post below)

As far as I understand msg_level option in ods excel is a printing option. It could be used to print the cells comments.

Based on that I've done some testing.

I've added a comment using the flyover style attribute on the John value

and a comment manually directly in the Excel file.

proc format;
    value $ chk 'John'='Flyover Example';
run;

ods excel file="&xxtest./reporting/ods_excel_test.xlsx";

proc report data=sashelp.class;
    column name age;
    define name / display style(column)=[flyover=$chk.];
    define age  / display;
run
;
ods excel close;

First we can see that the way Excel interpret those two solutions are different.

Then I've changed the printed options

When printing two pages are printed : one with the data and one with the comment entered manually.

The comment using SAS flyover style attribute is not displayed.

Given that there was 3 printed options. I've tried the third one too.

Here I would get a single page in the print preview, no difference with the "None" default setting.

Based on that I've not even tried msg_level as I'm not even sure what is the real working value beside NONE. NO NOTES doesn't really make sense to me in this context.

Any comment/suggestions?

Old post:

As anyone an example of use of the msg_level option in ods excel.

According to the SAS Online doc (https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/odsug/p09n5pw9ol0897n1qe04zeur27rv.htm)

(MSG_LEVEL= NO NOTES | NONE) suppresses messages from Excel.

But 1/ quotations marks are needed (error message otherwise) 2/ I'm not really sure what is meant Excel messages and even how to add them using ods excel before being able to remove them with msg_level.

Do you have any idea/example?

Cheers

topic msg_level optionin ods excel in ODS and Base Reporting

msg_level optionin ods excel