Hello,  I have data that may have changed from the last run of a report. I am bringing in the old report and merging with the new run. If a datapoint changes, I would like to use proc report to add a flyover comment in the excel cell to show the previous value. I am using SAS 9.4, ODS tagsets excelxp. I know how to add the flyover comment  like this:   compute mhstdat_raw; * Cell comment; if mhstdat_raw="09 Feb 2022" then call define(_col_, "style", "style=[background=yellow flyover='Value has changed']"); endcomp;   But, I have a lot of datapoints and the flyover needs to show the previous value which I have in the dataset. On the subject's record, I have the data variable that changed in a variable called VARIABLE and the previous value in a variable called VAL. I was hoping I could do something like this:   compute mhstdat_raw; * Cell comment; if variable="mhstdat_raw" then call define(_col_, "style", "style=[background=yellow flyover=val]"); endcomp;   I want to add the comment in the MHSTDAT_RAW cell with the value of VAL, but this does not work.   Any suggestions? Thanks! ... View more

Hello, I have read some posts on this topic, but nothing is working for me. I have a dataset with a variable called cal_date that is numeric with a date format (date11). In SAS 9.4 Proc Report I am using ODS tagsets and the define statement is as follows: DEFINE cal_date/display 'Calendar Date' format=date11.; I have tried this too - DEFINE cal_date/display 'Calendar Date' format=date11. style(column) = {tagattr="format:dd-mmm-yyyy"}; But in the excel output, I want to be able to use the date filter on this column and I cannot. It just gives me the text filter which is not helpful.         Any suggestions? Thanks! ... View more