Hi @annypanny    SAS put a warning in the log because it "wonders" if the variable "defautlname" refers to the same variable. Indeed, this variable is present in both input datasets and has common caracteristics: same type (otherwise you would have an error in the log) and same name. However, the length differs. To avoid this issue, you need to tell SAS what is the appropriate length first. To do that, you can specify it in a LENGTH statement. The PDV containing the variable definition is then correctly set up before filling in the dataset with the original values.   Best, ... View more

Hi @Amy0223    As the report is quite "simple", PROC PRINT provides good alternative to PROC REPORT: proc print noobs data = have label style(data)={backgroundcolor=lilg} style(header)={backgroundcolor=skyblue color=white fontweight=bold}; var leading_cause deaths; label leading_cause = "Leading Cause" deaths = "Deaths"; format deaths comma10. ; title j=c color=black "Leading Causes of Death, Tennessee, Resident Data, 2014-2017"; run ;     ... View more

Hi @sufiya  Could you please supply raw data? best, ... View more

You're welcome @nesslee 😊 ... View more

In this case, maybe a PROC TABULATE could be a more flexible solution? ... View more

Hi @MART1  I am afraid this does not work because "i" is not a macrovariable and you cannot refer directly to each new columns created by the "ACROSS" definition.   Please try this: proc report data=WORK.TEST nowd; column (YEAR, (EXPECTED MISSED TOTAL)); define YEAR / across 'YEAR'; define EXPECTED / analysis SUM 'EXP' missing; define MISSED / analysis SUM 'MISS' missing; define TOTAL / analysis SUM 'TOT' missing; compute YEAR; if (_C1_ + _c2_) = _c3_ then call define('_c3_','style','style={background=lightblue}'); if (_C4_ + _c6_) = _c6_ then call define('_c6_','style','style={background=lightblue}'); if (_C7_ + _c8_) = _c9_ then call define('_c9_','style','style={background=lightblue}'); if (_C10_ + _c11_) = _c12_ then call define('_c12_','style','style={background=lightblue}'); if (_C13_ + _c14_) = _c15_ then call define('_c15_','style','style={background=lightblue}'); if (_C16_ + _c17_) = _c18_ then call define('_c18_','style','style={background=lightblue}'); if (_C19_ + _c20_) = _c21_ then call define('_c21_','style','style={background=lightblue}'); if (_C22_ + _c23_) = _c24_ then call define('_c24_','style','style={background=lightblue}'); endcomp; run;     ... View more

Hi @FLCrime    Please try this: data have; input Person $ Registration $ Registration_Date; datalines; Pete A 2019 Marco A 1993 Sam B 2002 Sam B 2003 Sam C 1960 David A 2002 David A 2002 ; run; proc sort data=have out=have_sorted; by Person Registration Registration_Date; run; data want; set have_sorted; by Person Registration Registration_Date; if first.Registration then output; run; Best, ... View more