SAS: How to keep leading zeros in a variable while exporting your data set to Excel?

While working with SAS ODS , many problems may arise : one of them is keeping leading zeros in numeric or even character variables when one attempts to export them to an excel file.

Let us take for example these variables

Exporting this file to Excel via the ODS generate this result: Excel deleting all the leading zeros .

Actually this problem can be solved by adding simple options to your code

We can therefore have the desired Output.

Share this :