topic Re: Conditional formating in SAS in ODS and Base Reporting

Conditional formating in SAS

aarathi — Wed, 15 Jun 2016 09:35:28 GMT

Can anyone tell me how to do conditional formatting in SAS.

regards,

arthi

Re: Conditional formating in SAS

RW9 — Wed, 15 Jun 2016 09:50:25 GMT

Assuming you mean traffic lighting in a report:

https://communities.sas.com/t5/SAS-Procedures/Conditional-formatting-Colors-Colours/td-p/132489

If not, please specify your question, giving details such as test data (form of datastep) and example output.

Re: Conditional formating in SAS

Reeza — Wed, 15 Jun 2016 14:09:31 GMT

What type of report are you generating, PDF, RTF, HTML, Excel?

You can use Proc report to implement conditional highlighting.

Re: Conditional formating in SAS

Ksharp — Thu, 16 Jun 2016 03:18:35 GMT

Here is an example:

proc fcmp outlib=work.functions.smd;
function ftoc(f) $;
length r $ 10;
if f=210 then r='C';
 else if f=211 then r=put(f,yymmdd10.);
  else r='N';
return (r);
endsub;
run;


options cmplib=(work.functions);
proc format;
value ftoc(default=10) other=[ftoc()];
run;
data have;
input  c ;
cards;
210 
211 
212
;
run;
data have;
 set have;
 format c ftoc10.;
run;
proc print;run;