Hi @SASnewbie2    You can update your title statement as follows, using th INTNX() function to retrieve the day before today:   title j = left "THE FIRST FIVE OBSERVATIONS OUT OF 19 AS AT %left(%qsysfunc(intnx(day,%sysfunc(Today()),-1),NLDATE20.))"; I have used %left rather than %trim to remove leading blanks.     To split the dataset by Name and save each report in a separate worksheet, there is no need to use do loop statement.  You can leverage the "BY" statement as follows:   - add a BY statement in the PROC REPORT   proc report data=sashelp.class (obs=5) nowd style(header)={backgroundcolor=lightblue fontweight=bold}; by name notsorted; - Add SHEET_INTERVAL = "bygroup" in the ODS EXCEL options: ODS EXCEL OPTIONS(AUTOFILTER="1-5" SHEET_INTERVAL = 'bygroup' EMBEDDED_TITLES='YES'); Best,     ... View more

Hi @SASnewbie2    If you want to stick to PROC PRINT, the only way to display 'Total' is to put it as a label in the observation number column: proc print data=sashelp.class (obs=5) grandtotal_label="Total"; sum age / style(grandtotal)={borderbottomstyle=solid bordertopstyle=solid borderbottomcolor=red bordertopcolor=red}; run; ... View more

Hi @SASnewbie2    Please try the following code, using PROC REPORT, to add "total" in the first column. I am not sure to understand what you want to display in the title after "as". Could you please specify? Best, ODS EXCEL OPTIONS(AUTOFILTER="1-5" SHEET_NAME = "TERMINAL COMPARISON" EMBEDDED_TITLES='YES'); proc report data=sashelp.class (obs=5) nowd style(header)={backgroundcolor=lightblue fontweight=bold}; title j = left "THE FIRST FIVE OBSERVATIONS OUT OF 19 AS AT %TRIM(%QSYSFUNC(DATE(), NLDATE20.))"; column Name Sex Age Height Weight; define Name / display; define Sex / display; define Age / analysis; /* <--- specify analysis if you want to compute the total */ define Height / display; define Weight / display; rbreak after / summarize style={backgroundcolor=lightblue}; compute after; if _BREAK_ = "_RBREAK_" then do; Name="Total"; /* Specify _c3_ as "age" is the 3rd column in the report */ call define ('_c3_','style','style={BORDERBOTTOMSTYLE=SOLID BORDERTOPSTYLE=SOLID}'); end; endcomp; run; ODS EXCEL CLOSE; ... View more

Hi @SASnewbie2    Using proc print, you can add a style option to specify a border on the summary cell: sum country / style(grandtotal)={borderbottomstyle=solid bordertopstyle=solid}; You can also specify the color and many other attributes (e.g. borderbottomcolor = black)   I am not sure that you can add "Total" using PROC Print. Proc report should be the best option to achieve this. Could you please share a portion of the data in regular datalines so that we can show you the code?   Best, ... View more

Here is an example: proc template; define style Styles.Custom; parent = Styles.Default; style data / backgroundcolor=yellow; /*<- to be customized */ end; run; ods html file="your_path/your_report.html" style=custom; proc print data=sashelp.class; run; ods html close; ... View more

Hi @Sarah-R    You can use PROC TEMPLATE to define your own style options, and then use this style in the ODS HTML statement. Here is an example: https://support.sas.com/kb/23/420.html   Best, ... View more

Here is another option, using the PROC TRANSPOSE procedure and the CATX() function: data have; input Type:$20. Car:$20.; datalines; Sedan Verna Sedan HondaCity Sedan Altis SUV Fortuner SUV Scorpio Hatchback Santro Hatchback Micra ; run; proc sort data=have; by type; run; proc transpose data=have out=have_tr (drop=_:); var car; by type; run; data want; set have_tr; car = catx(",",of col:); drop col:; run; ... View more

Hi @Laylitta    We can see the rows now 😊 Please try this: by mif descending src_ref; if last.src_ref then output; Best, ... View more

Hi @Laylitta    There is no yellow rows 😉 Could you please update your post with the last part? ... View more