Changing Row Color With Proc Report

[AKNess]

I would like to create a PDF report that has different colored rows based on the value of my variable type. I would like the rows to be green when type='Complete', yellow when type='Planned' and red when type='At Risk'. I have tried running the following compute block:

     compute type;

     if type='Complete' then call define (_row_,'style','style=[BACKGROUND=lightGREEN]');

     if type='Planned' then call define (_row_,'style','style=[BACKGROUND=lightYELLOW]');

     if type='At Risk' then call define (_row_,'style','style=[BACKGROUND=lightRED]');

     endcomp;

I have used a run statement as well as an ods pdf close statement at the end of the proc report step but when I run this section of my code SAS indicates that Proc Report is still running and will not produce the PDF file. How can I successfully produce this report?

[Reeza]

Full code please and log please.

Did you include nowd in the proc report statement as well?

[AKNess]

My full code looks like this:

I'm not very familiar with Proc Report and am not sure if I'm using any of the options correctly.

[Reeza · Accepted solution]

Add the nowd (nowindows) option to your proc report statement. Proc Report can be an interactive procedure, so you want to tell SAS that you want it to be non-interactive.

proc report data=panel_1 nowd;

[AKNess]

That did it! Thank you!