The DATA step that sets the headers should be executed before the DATA step that writes content to _WEBOUT.  This won't solve your problem but at least the code will be written correctly.   Try adding this line of code to the end of your program to see if it helps:   %let _STATUS_MESSAGE=Programm beendet.;   Vince DelGobbo SAS R&D     ... View more

I don't know of a way to have ODS embed excel formulas into an excel file.   As a workaround, you could use R and a package like openxlsx or xlconnect and SAS IML to add Excel functions to an excel spreadsheet.   To improve the functionality of creating excel files from within SAS, I create the data to be placed into an excel file using SAS and then call IML from within SAS to invoke R, pass the data to R and any commands associated with openxlsx or xlconnect to create and modify the excel file I want to create.   This paper provides details on how we do that: https://analytics.ncsu.edu/sesug/2017/SESUG2017_Paper-109_Final_PDF.pdf   ... View more