Using the FLOW= suboption in a SAS^® Output Delivery System (ODS) statement for Microsoft Excel along with PROC TABULATE causes numbers to be stored as text.

When numbers are stored as text in an Excel worksheet, the values cannot be used in calculations. Starting with SAS^® 9.4M5, the FLOW= ODS suboption can cause numbers to be stored as text.

Here is an example of the code that creates this issue in SAS 9.4M5:

The affected cells have green triangles at the top left of each cell, indicating that the numbers are stored as text. The following image shows an example of these triangles:

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for this issue for ODS Templates 9.4_M6 is available at:

A fix for this issue for ODS Templates 9.4_M5 is available at: