Hi:
The message has nothing to do with the use of ' ' for the ID items. If you review the program in the SAS log (shown #1 below), you can see that I have used ' ' for both ID items without any messages.
I'm also not sure what you're trying to do with the PAGE option, however, this option will work differently for ODS destinations than it does for the LISTING destination, as described here:
http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/a002473627.htm#a003072105
In listing destinations, a PAGE option on the DEFINE statement causes PROC REPORT to print this column and all columns to its right on a new page. However, for ODS MARKUP, HTML, PRINTER , and RTF destinations, the page break doesn't occur until all the rows in the report have been printed. Therefore, PROC REPORT prints all the rows for all the columns to the left of the PAGE column and then starts over at the top of the report and prints the PAGE column and the columns to the right.
The message is complaining about an incorrect usage of cellwidth. I believe it's happening because you have the incorrect syntax for the STYLE= override -- usually, PROC REPORT won't complain, but in this case, I believe you're getting the WARNING message because when ODS tries to calculate the proper widths, it doesn't know which table element (header or column) you intend to alter with your STYLE= syntax. If you look at the #2 program in the SAS log, you will see that I can duplicate your warning message with the same incorrect usage.
With PROC REPORT, the usual syntax for STYLE= overrides is:
style(header)={attribute=value} OR
style(column)={attribute=value}
...and, in fact, if I alter my code to use this form of STYLE override, the warning message disappears (as shown #3 LOG below).
cynthia
#1 program LOG shows that you can use ' ' on DEFINE with ID;
[pre]
1985 ods html file='blank_id.html' style=sasweb;
NOTE: Writing HTML Body file: blank_id.html
1986 ods rtf file='blank_id.rtf' style=journal;
NOTE: Writing RTF Body file: blank_id.rtf
1987 ods pdf file='blank_id.pdf';
NOTE: Writing ODS PDF output to DISK destination "C:\temp\blank_id.pdf", printer "PDF".
1988
1989 proc report data=sashelp.class nowd;
1990 column name sex age height weight;
1991 define name / id display ' ';
1992 define sex / id display ' ';
1993 define age / display 'Age';
1994 define height / display 'Ht';
1995 define weight / display 'Wt';
1996 run;
NOTE: There were 19 observations read from the data set SASHELP.CLASS.
NOTE: PROCEDURE REPORT used (Total process time):
real time 0.18 seconds
cpu time 0.06 seconds
1997 ods _all_ close;
[/pre]
#2: However, I CAN duplicate your WARNING message by altering the program as shown below:
[pre]
2002 ods html file='dup_msg.html' style=sasweb;
NOTE: Writing HTML Body file: dup_msg.html
2003 ods rtf file='dup_msg.rtf' style=journal;
NOTE: Writing RTF Body file: dup_msg.rtf
2004 ods pdf file='dup_msg.pdf';
NOTE: Writing ODS PDF output to DISK destination "C:\temp\dup_msg.pdf", printer "PDF".
2005
2006 proc report data=sashelp.class nowd;
2007 column name sex age height weight;
2008 define name / id display ' ' style=[cellwidth=25%] ;
2009 define sex / id display ' ' style=[cellwidth=25%] ;
2010 define age / display 'Age' style=[cellwidth=25%] ;
2011 define height / display 'Ht' style=[cellwidth=25%] ;
2012 define weight / display 'Wt' style=[cellwidth=20%] ;
2013 run;
WARNING: Use of CELLWIDTH/OUTPUTWIDTH= in a spanning header or footer will rarely yield
expected results. For conventional usage, specify outputwidth only for the data
column cells.
WARNING: Use of CELLWIDTH/OUTPUTWIDTH= in a spanning header or footer will rarely yield
expected results. For conventional usage, specify outputwidth only for the data
column cells.
NOTE: There were 19 observations read from the data set SASHELP.CLASS.
NOTE: PROCEDURE REPORT used (Total process time):
real time 0.18 seconds
cpu time 0.07 seconds
2014 ods _all_ close;
[/pre]
#3: Note that with correct syntax for STYLE override there is no warning in the LOG:
[pre]
2019 ods html file='no_msg.html' style=sasweb;
NOTE: Writing HTML Body file: no_msg.html
2020 ods rtf file='no_msg.rtf' style=journal;
NOTE: Writing RTF Body file: no_msg.rtf
2021 ods pdf file='no_msg.pdf';
NOTE: Writing ODS PDF output to DISK destination "C:\temp\no_msg.pdf", printer "PDF".
2022
2023 proc report data=sashelp.class nowd;
2024 column name sex age height weight;
2025 define name / id display ' ' style(column)=[cellwidth=25%] ;
2026 define sex / id display ' ' style(column)=[cellwidth=25%] ;
2027 define age / display 'Age' style(column)=[cellwidth=25%] ;
2028 define height / display 'Ht' style(column)=[cellwidth=25%] ;
2029 define weight / display 'Wt' style(column)=[cellwidth=20%] ;
2030 run;
NOTE: There were 19 observations read from the data set SASHELP.CLASS.
NOTE: PROCEDURE REPORT used (Total process time):
real time 0.17 seconds
cpu time 0.06 seconds
2031 ods _all_ close;
[/pre]