topic How do I assign requested colors in proc sgplot in SAS Programming

How do I assign requested colors in proc sgplot

mmohotsi — Fri, 12 May 2023 10:41:14 GMT

Good day,

I need to color the graphs drawn according to the customer requirements. The customer only need yellow, green, red and orange for each point in the data set.

The program below only provides colors set by SAS. Can you help modify the program to assist the customer or is there any other way I could follow to assist the customer?

%let date1=%sysfunc(today(),date9.);

%Let reports = <library>;

ods _all_ close;

ODS excel FILE = "&reports\Metsi_Charts &date1..xlsx";

OPTIONS PAGESIZE=MAX ORIENTATION=LANDSCAPE;

ods graphics on / width=27.94cm height=15.24cm noscale;

ods excel options(autofilter="1-6" sheet_name = "Determinand " embedded_titles='yes');

proc sgplot data=datasets.Metsi2 ;

vline dates / response=value group=point groupdisplay=cluster ;

yaxis values=(0 to 2.4 by 0.2) label='Determinand' grid LABELATTRS=(weight=bold family=Helvetica size=7 )

VALUEATTRS=(family=Helvetica size=7 style=normal weight=normal ) ;

refline 0.1 / axis=y label=('0.1 mg/L') lineattrs=(color=red pattern=dash) labelattrs=(size=7) labelloc=inside;

xaxis interval=day VALUESROTATE=VERTICALlabel='Sampled dates' LABELATTRS=(weight=bold size=7) valuesrotate=vertical

VALUEATTRS=(family=arial size=10 style=normal weight=normal ) type=time;

title1 j=c "Metsi Determinand trend" bold;

title;

run;

Re: How do I assign requested colors in proc sgplot

PaigeMiller — Fri, 12 May 2023 11:37:44 GMT

Are you talking about using these colors in VLINE or somewhere else? Explain further. Please be specific.

Re: How do I assign requested colors in proc sgplot

yabwon — Fri, 12 May 2023 13:16:09 GMT

Use attribute maps:

here is the doc. with examples: https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/grstatgraph/n06cil5e9uw87mn1n7pzfefidh04.htm

here is a tutorial by Joshua Horstman: https://www.youtube.com/watch?v=Wm8VkqDjBps

Bart

Re: How do I assign requested colors in proc sgplot

mmohotsi — Fri, 12 May 2023 13:32:24 GMT

Yes. I think the vline step could be the appropriate step to include these colors for each point. Thanks

Re: How do I assign requested colors in proc sgplot

PaigeMiller — Fri, 12 May 2023 13:52:16 GMT

So, explain further. Do you want specific colors for specific VLINEs? I don't understand how the colors are used.

Re: How do I assign requested colors in proc sgplot

mmohotsi — Fri, 12 May 2023 13:58:09 GMT

Good day

Each vline corresponding to a point should have its own color. When I run this SAS code it gives each vline a color that I did not select. So I want to assign each vline a specific color of my choice.