04-06-2018 08:19 AM
If you are outputting the results of PROC REPORT to Excel via ODS EXCEL or ODS TAGSETS.EXCELXP, then freezing the top row in place is possible, as this is a feature of Excel.
ods excel file="myfolder\ods_excel_example.xlsx" options(frozen_headers="ON");
If you are outputting the results to some other destination, it probably isn't possible as there is no concept of freezing the top row in the other destinations.
04-06-2018 12:38 PM