In reply to Meenakshi.

PROC EXPORT sends just data, not formatted report output. ODS EXCEL allows you to add more formatting/style options to control the look of your Excel content.