About Cannon3006

Cannon3006 · ‎02-09-2021

Hi, Is it possible to color the class variable using different dynamic rules (traffic light coloring) for each column. I am trying to color VAR2 (class1) using one rule, VAR2 (class3) using another rule... this code will color the whole table using the same "traffic" format, but I want to have 3 independent traffic rules. PROC FORMAT; VALUE TRAFFIC LOW-<30='RED' 30-50='YELLOW' 50< - HIGH= 'GREEN'; RUN; PROC TABULATE DATE=INPUT_TABLE; CLASS VAR1; CLASS VAR2; TABLE VAR1, VAR2*[STYLE=[BACKROUND=TRAFFIC.]; RUN; Thanks,

Cannon3006 · ‎02-09-2021

Yes, but that format works even without decsep=',' .The decsep seems to only work without the multiplication option. I was just curious why.

Cannon3006 · ‎02-03-2021

This worked great for me also. Is it possible to combine decsep and mult, to convert 0.325 to 32,5%. The code below did not work. proc format; picture fmt other = '09,99%' (decsep=',' mult=100); run; However I did get it working using the method from the answer, I just wanted to know why mult and decsep did not work together. proc format; picture fmt other = '009,99%' (mult=10000); run;

Cannon3006 · ‎12-26-2020

Hi, I'm having a problem getting ROW_SPAN=2 option working for ODS Region on a PDF document. The area I marked in yellow is the area the output is limited to although it should be spanning across the two rows. My SAS version is 7.15. ODS LAYOUT GRIDDED COLUMNS=2 ADVANCE=OUTPUT; ODS REGION ROW_SPAN=2;PROC DOCUMENT NAME=DOC1;REPLAY SGPLOT#1; RUN; QUIT; ODS REGION; PROC DOCUMENT NAME=DOC2; REPLAY PRINT#1; RUN; QUIT; ODS REGION; PROC DOCUMENT NAME=DOC3; REPLAY PRINT#1; RUN; QUIT; ODS LAYOUT END;

Cannon3006 · ‎11-04-2020

Thanks that's exactly what I was looking for.

Cannon3006 · ‎11-04-2020

Hi, I'm trying to convert numbers such as 32.5 to 32,5% using a format. Below is the link to the format which adds the % symbol but I can't seem to find one which converts it to European decimal convention as well. https://support.sas.com/kb/38/001.html Thanks, Mladen

Online Status	Offline
Date Last Visited	‎02-19-2021 10:49 AM

Proc tabulate and class traffic coloring

Re: rayRe: Format for % and European Decimal convention

Re: rayRe: Format for % and European Decimal convention

ODS Region and ROW_SPAN (PDF) not working

Re: Format for % and European Decimal convention

Format for % and European Decimal convention

Re: Proc tabulate and class traffic coloring

Proc tabulate and class traffic coloring

Re: rayRe: Format for % and European Decimal convention

Re: rayRe: Format for % and European Decimal convention

ODS Region and ROW_SPAN (PDF) not working

Re: Format for % and European Decimal convention

Format for % and European Decimal convention