topic Re: Excel in ODS and Base Reporting

Excel

jdmarshg — Sat, 16 Jan 2016 01:51:10 GMT

Hello everyone,

I'm using the ODS to create an excel report with alternating colors for rows.

I'm now trying to get a row to change color based on a returned value within the row.

if job_rc = 4 then yellow/orange.

Any suggestions to point me in the right direction of adding this functionality?

Regards,

Jonathan

Re: Excel

Reeza — Sat, 16 Jan 2016 02:47:16 GMT

How are you creating your report. What ODS destination are you using?

Please post your code.

The quick answer is proc report with a compute column - search for papers on the topic.

Re: Excel

Ksharp — Mon, 18 Jan 2016 02:51:12 GMT


ods excel file= "/folders/myfolders/report.xlsx" ;
proc report data=sashelp.class nowd ; 
 column name age;
 define name/ "" display style={cellwidth=2.5in};
 define age/ "" display style={cellwidth=2.5in};
 

  compute age;
  if age le 14 then 
  call define(_row_,"Style","Style={background=yellow}"); 
 endcomp;

run; 

ods excel close;

Re: Excel

jdmarshg — Mon, 18 Jan 2016 02:56:20 GMT

Hello yes I was able to find documentation on the topic to get the issue resolved.

Re: Excel

BoelterBI — Fri, 03 Mar 2017 19:58:05 GMT

Hi,

ODS excel file= "~/YOURS.xlsx" ;
proc report data=DB.TABLE nowd ;
column name VALUE;
define CITY/ "" display style={cellwidth=3.0in};
define POPULATION/ "" display style={cellwidth=3.0in};

compute CITY;
if age LESS 50000 then
call define(_row_,"Style","Style={background=BLUE}");
end
comp;

run;