Hi All,   I am trying to create a SALES report using Proc Report for two categories of customers as of now (Corporates & Non-Corporates). I am able to create the Datasets with all the calculations using Proc Reports, but now I need to Export this Proc Report to EXCEL(.XLSX) in two different sheets Corporates and Non-Corporates. I am aware that this can be done using Proc Export and writing the data into two different Sheets in the Same Excel. I'm trying to Keep the Format and the report as it's in Excel, and the Footnote of the report Should display the Tukey Fences.  I have calculated the Upper Bound and Lower Bounds using proc Univarate and have created macro variables for the Upper Bounds and Lower Bounds. Something like this: Proc Univariate data = Sale012020 outtable = SaleJan20 Noprint; Var Sales_Amount; Run;   /*UPPER NAD LOWER BND CALCULATIONs*/ DATA SaleJan20 ; Set SaleJan20 ;   lower = _Q1_ - (1.5*_QRANGE_); /*_QRANGE_ = Interquartile Range*/ UPPER= _Q3_+ (1.5*_QRANGE_) /*_QRANGE_ = Interquartile Range*/ Run;   Data _NULL_; Set SaleJan20 ; Call Symput('UPPER',UPPER); CALL SYMPUT('LOWER',LOWER); RUN;   The Format for the UPPER and LOWER needs to percent8.2 When I tried to apply the Percent to the Macro Variables on the Report it is Displayed as 1.6E %(For E.g.)   I have tried using the ODS Exceltagsets and ODS excel File = options(); I am able to write the Output for (for e.g. Corporates ) to a sheet in the excel workbook, but not able to retain the formats and write the output of ( Non-Corporates) in another sheet.   Could you please guide or Suggest this?   Please find the attached Sales input and report in excel attached. Kindly note that I have created the Tukey Fences using Excel formulas and the Sales Amounts or Sale numbers are fictitious.     Regards,           ... View more