[prev in list] [next in list] [prev in thread] [next in thread]
List: sas-l
Subject: Re: conditional (from another variable) highlight a column in proc report
From: Kai Yang <00000f1278aa5087-dmarc-request () LISTSERV ! UGA ! EDU>
Date: 2023-01-10 16:39:00
Message-ID: 148741102.4438849.1673368740644 () mail ! yahoo ! com
[Download RAW message or body]
Hi Bartosz,Thank you for your help. It is exactly what I need.Best,Kai
On Tuesday, January 10, 2023 at 02:43:46 AM PST, Bartosz Jabłoński \
<yabwon@gmail.com> wrote:
try this:
data cars;
set sashelp.cars(obs=13);
if msrp ge 30000 then flag1=1;
if msrp le 24000 then flag2=1;
keep make model msrp flag1 flag2;
run;
proc report data=cars nowd;
column flag1 flag2 make model msrp;
define flag1 / NOPRINT;
define flag2 / NOPRINT;
define msrp / display;
compute msrp;
if flag1.sum=1 then
do;
call define(_col_, 'style', 'style=[backgroundcolor=lightgreen]');
end;
else if flag2.sum=1 then
do;
call define(_col_, 'style', 'style=[backgroundcolor=red]');
end;
endcomp;
run;
Bart
pon., 9 sty 2023 o 22:53 Kai Yang <00000f1278aa5087-dmarc-request@listserv.uga.edu> \
napisał(a):
Hi Team,I need to conditional color a column. in the example, I assign the light \
green color for msrp column. It is working. But I want to use the conditional from \
other variable, say flag. I created flag in data step and it is exactly identify the \
same case if msrp >= 30000. I want use it as a condition in proc report.I was trying \
replace "if msrp ge 30000 then call define(_col_, 'style', \
'style=[backgroundcolor=lightgreen]');" to be "if flag=1 then call define(_col_, \
'style', 'style=[backgroundcolor=lightgreen]');" but it doesn't work. Is it a way to \
make this work?Thank you,Kai
data cars; set sashelp.cars;
if _n_ < 10; format flag 1.; if msrp ge 30000 then flag=1; keep make model \
msrp flag;run; proc report data=cars nowd;
column make model msrp flag; define flag/noprint; define msrp / display; compute \
msrp; if msrp ge 30000 then call define(_col_, 'style', \
'style=[backgroundcolor=lightgreen]'); endcomp; run;
[Attachment #3 (text/html)]
<html><head></head><body><div class="ydp45d4cccayahoo-style-wrap" \
style="font-family:Helvetica Neue, Helvetica, Arial, \
sans-serif;font-size:13px;"><div></div> <div dir="ltr" data-setdir="false">Hi \
Bartosz,</div><div dir="ltr" data-setdir="false">Thank you for your help. It is \
exactly what I need.</div><div dir="ltr" data-setdir="false">Best,</div><div \
dir="ltr" data-setdir="false">Kai</div><div><br></div>
</div><div id="yahoo_quoted_4034619640" class="yahoo_quoted">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, \
sans-serif;font-size:13px;color:#26282a;">
<div>
On Tuesday, January 10, 2023 at 02:43:46 AM PST, Bartosz \
Jabłoński <yabwon@gmail.com> wrote: </div>
<div><br></div>
<div><br></div>
<div><div id="yiv0560045994"><div><div dir="ltr"><div \
style="font-family:monospace, monospace;" class="yiv0560045994gmail_default">try \
this:</div><div style="font-family:monospace, monospace;" \
class="yiv0560045994gmail_default"><br clear="none"></div><div \
style="font-family:monospace, monospace;" class="yiv0560045994gmail_default"><font \
color="#0000ff">data cars;<br clear="none"> set sashelp.cars(obs=13);<br \
clear="none"> if msrp ge 30000 then flag1=1;<br clear="none"> if msrp \
le 24000 then flag2=1;<br clear="none"> keep make model msrp flag1 \
flag2;<br clear="none">run;<br clear="none"><br clear="none"><br clear="none">proc \
report data=cars nowd;<br clear="none"> column flag1 flag2 make model msrp;<br \
clear="none"> define flag1 / NOPRINT;<br clear="none"> define flag2 / \
NOPRINT;<br clear="none"> define msrp / display;<br clear="none"> compute \
msrp;<br clear="none"><br clear="none"> if <b>flag1.sum</b>=1 then \
<br clear="none"> do;<br clear="none"> \
call define(_col_, 'style', 'style=[backgroundcolor=lightgreen]');<br \
clear="none"> end;<br clear="none"> else if \
<b>flag2.sum</b>=1 then <br clear="none"> do;<br \
clear="none"> call define(_col_, 'style', \
'style=[backgroundcolor=red]');<br clear="none"> end;<br \
clear="none"> <br clear="none"> endcomp;<br clear="none">run;</font><br \
clear="none"></div><div style="font-family:monospace, monospace;" \
class="yiv0560045994gmail_default"><br clear="none"></div><div \
style="font-family:monospace, monospace;" \
class="yiv0560045994gmail_default">Bart</div><div style="font-family:monospace, \
monospace;" class="yiv0560045994gmail_default"><br clear="none"></div></div><br \
clear="none"><div class="yiv0560045994gmail_quote"><div dir="ltr" \
class="yiv0560045994gmail_attr">pon., 9 sty 2023 o 22:53 Kai Yang <<a \
rel="nofollow noopener noreferrer" shape="rect" \
ymailto="mailto:00000f1278aa5087-dmarc-request@listserv.uga.edu" target="_blank" \
href="mailto:00000f1278aa5087-dmarc-request@listserv.uga.edu">00000f1278aa5087-dmarc-request@listserv.uga.edu</a>> \
napisał(a):<br clear="none"></div><div id="yiv0560045994yqt35223" \
class="yiv0560045994yqt5659476537"><blockquote style="margin:0px 0px 0px \
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex;" \
class="yiv0560045994gmail_quote"><div><div style="font-family:Helvetica, Arial, \
sans-serif;font-size:13px;"><div dir="ltr">Hi Team,</div><div dir="ltr">I need to \
conditional color a column. in the example, I assign the light green color for msrp \
column. It is working. But I want to use the conditional from other variable, say \
flag. I created flag in data step and it is exactly identify the same case if msrp \
>= 30000. I want use it as a condition in proc report.</div><div dir="ltr">I was \
trying replace "<span><span style="font-family:Helvetica, Arial, \
sans-serif;"><b><i><font color="#9d1811">if msrp ge 30000 then call define(_col_, \
'style', 'style=[backgroundcolor=lightgreen]');</font></i></b>" to be "<span \
style="font-family:Helvetica, Arial, sans-serif;"><b><i><font color="#4c76a2">if \
flag=1 then call define(_col_, 'style', \
'style=[backgroundcolor=lightgreen]');</font></i></b>" but it doesn't work. Is it a \
way to make this work?</span></span></span></div><div dir="ltr"><span><span \
style="color:rgb(0,0,0);font-family:Helvetica, Arial, sans-serif;"><span><span \
style="color:rgb(0,0,0);font-family:Helvetica, Arial, sans-serif;">Thank \
you,</span></span></span></span></div><div dir="ltr"><span><span \
style="color:rgb(0,0,0);font-family:Helvetica, Arial, sans-serif;"><span><span \
style="color:rgb(0,0,0);font-family:Helvetica, Arial, \
sans-serif;">Kai</span></span></span></span></div><div><br \
clear="none"></div><div><br clear="none"></div><div dir="ltr"><div><div>data \
cars;</div><div> set sashelp.cars;</div><div><br \
clear="none"></div><div> if _n_ < 10;</div><div><span \
style="white-space:pre-wrap;"> </span>format flag 1.;</div><div><span \
style="white-space:pre-wrap;"> </span>if msrp ge 30000 then \
flag=1;</div><div> keep make model msrp \
flag;</div><div>run;</div><div><br clear="none"></div><div>proc report data=cars \
nowd;<br clear="none"></div><div><span style="white-space:pre-wrap;"> </span>column \
make model msrp flag;</div><div><span style="white-space:pre-wrap;"> </span>define \
flag/noprint;</div><div><span style="white-space:pre-wrap;"> </span>define msrp / \
display;</div><div><span style="white-space:pre-wrap;"> </span>compute \
msrp;</div><div><span style="white-space:pre-wrap;"> </span>if msrp ge 30000 then \
call define(_col_, 'style', 'style=[backgroundcolor=lightgreen]');</div><div><span \
style="white-space:pre-wrap;"> </span>endcomp;</div><div><br \
clear="none"></div><div>run;</div></div><br \
clear="none"></div></div></div></blockquote></div></div> </div></div></div>
</div>
</div></body></html>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic