About DanSturgeon

DanSturgeon · ‎05-01-2014

Thanks Cynthia and Scott, funny enough when you mentioned reading your paper I was literally holding onto it, haha. My code I listed wasn't totally representative of what I actually had, I did have the target in the column statement. My issue ended up being that in the call define statement I was not specifically calling out the specific column, but instead doing a less specific _Col_. So that was the issue, but now I am good. Thank you very much. Scott, great tip on the columns I was just counting them. You saved me some time,,,haha. Thanks to the both of you for your help.

DanSturgeon · ‎04-16-2014

I am trying to do simple traffic lighting in a PROC REPORT using a cutoff that is in another variable across variables that are in an ACROSS statement. proc report data=combined2 nowd style(header)={background=green}; column NAME MEAS_DESC,MEAS_SCORE; DEFINE NAME / '' GROUP ORDER=Data; DEFINE MEAS_DESC / '' ACROSS ORDER=DATA style(header)=vertical_header; DEFINE meas_score / '' ; run; There is another variable 'Target" that can be added which is the target I want to compare them to. I tried comparing the numbers in a compute statement which did not work then I tried to create a variable which already had the logic within it (if score < target then a = 1) and put that into a compute as well. That did not work. Is it possible to do this in normal code or will I need to write the macro that I am trying to avoid? Edits made to simplify question Message was edited by: Dan Sturgeon

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Re: Conditional Coloring for PROC REPORT with ACROSS variable

Conditional Coloring for PROC REPORT with ACROSS variable

Re: Conditional Coloring for PROC REPORT with ACROSS variable

Conditional Coloring for PROC REPORT with ACROSS variable