This could be one of the fancy data optimizations implemented in Excel itself.
But: Are you sure, that you have applied the format comma10.10? If I try to do so, the log displays:
The decimal specification of 10 must be less than the width specification of 10.
Changing the format to comma15.10 fixed the issue.
Maxim 2: Read the Log.
It will alert you to the fact that you used an invalid format specification. The number to the left of the dot must accommodate
I suggest to use 20.10 as a start and see what it does.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.