Thanks for another very unhelpful reply. ... View more

I have 8 tabs of 3 cross tabs. I can't see this being the right answer. ... View more

Let me know if you see a solution for the empty cells issue. I cannot share industry sensitive information with you. Have a good day. ... View more

Yes, that's right, they're not high enough quality to present in my business world. Putting in "a hell of a lot of work" to come out with amateur/clinical looking graphics is not something I am interested in. ... View more

`Thanks for the reply.  SAS Graphs do not have enough control to be considered "presentation quality" in my line of work.  It's a fine tool for quick analytics, but it's not good enough for executive reporting.   I'm still certain there's a path here, ODS HTML creates a true empty, so SAS certainly has the ability to do so.  Just need to figure out what control handles it. ... View more

Yes, I saw that post yesterday.  Unfortunately, it's not true.  As mentioned in my original post here, Report doesn't fix this either.   I have tried several option missing='' type solutions, I have tried both ODS, I have tried XML,XLS, and XLSX.  I have tried tabulate and report. ... View more

I need nothing in the cell. Nothing at all: not zero, NA, space.... nothing. It has to be able to return TRUE for =isblank(). With ODS HTML, this was the case, but something is different about the output, as seen above with the XML examples. ... View more

What part was unclear? ... View more

The =NA() formula in Excel returns #N/A in the cell, which Excel won't graph.  If I could get that value to somehow populate the cells, that'd work. ... View more

Here's one of the cells from looking at the XML output using Tagsets.ExcelXP   <Cell ss:StyleID="data__r1" ss:Index="16"><Data ss:Type="String"></Data></Cell>   That same cell using ODS HTML: <td class="r b data" #,##0_);[Red](#,##0);_("-"??_)>&nbsp;</td>   Here is an example on how the tagset XML is changing the cell format when it sees missing:   <Cell ss:StyleID="data__r1" ss:Index="15"><Data ss:Type="Number">89987</Data></Cell> <Cell ss:StyleID="data__r1" ss:Index="16"><Data ss:Type="String"></Data></Cell>    You can see it changes from number to string. ... View more

Can you modify the code I provided to an output that will pass the isblank() test? ... View more

Here's some very simple code.   data test; input month sales; datalines; 1 10 2 20 3 30 4 . 5 50 6 60 ; run; option missing=''; %let myWorkLocation = %sysfunc(pathname(work)); ods tagsets.excelxp file= "&myWorkLocation./test.xml"; proc tabulate data = test missing; class month; var sales; table (month='')*(sales='' *sum=''); run; ods tagsets.excelxp close;     As long as the excel book returns FALSE for =isblank(D2), this won't work.   SAS' graphing capabilities are fine for analysis, they are terrible for presentation.  ... View more

My information was fine. I asked about getting a bold header using ODS Excel and you responded with what format to use with ODS Tagsets.ExcelXP. That's why I assumed you were lost - you answered a question that nobody asked. That's the same thing Cynthia did. Have a good day. ... View more

I'm not sure if you meant to reply to someone else, but my question was regarding using ODS Excel.  Have a good day. ... View more