topic Re: Change default colors in SGPLOT in Graphics Programming

Change default colors in SGPLOT

Forecaster — Fri, 06 Mar 2015 16:00:46 GMT

I'm reading "Statistical graphics procedures by example" by Matange and Heath. I'm trying to modify the colors in the sgplot in the example below, but so far I have been not sucessful. Please see below for an example. I'm trying to change the color of "actual" by individual products.

data attrs;

input id $ value $ fillcolor $;

datalines;

actual A Blue

actual B Black

actual B Green

actual D Yellow

;

run;

proc sgplot data = sgbook.product_sales dattrmap=attrs;

hbar product /response = actual barwidth=0.5 attrid=id;

hbar product /response=predict barwidth=0.2;

run;

The above code does not work, how would I change the color for individual products.

Re: Change default colors in SGPLOT

DanH_sas — Fri, 06 Mar 2015 18:15:33 GMT

The problem is that the ATTRID is incorrect. The ATTRID should be the *value* in the ID column -- not the ID column name itself. The ID column is a reserved column name in an ATTMAP, so it does not need to be referenced. In your case, set attrid=actual, and you should get the correct result.

Re: Change default colors in SGPLOT

Forecaster — Fri, 06 Mar 2015 18:48:02 GMT

@DanH, I changed the code following your suggestion, I still do not get the color change, Can you please help

data attrs;

input id $ value $ fillcolor $;

datalines;

ACTUAL A Blue

ACTUAL B Black

ACTUAL C Green

ACTUAL D Yellow

;

run;

proc sgplot data = sgbook.product_sales dattrmap=attrs;

hbar product /response = actual barwidth=0.5 attrid=actual;

hbar product /response=predict barwidth=0.2;

run;

Re: Change default colors in SGPLOT

DanH_sas — Fri, 06 Mar 2015 19:17:33 GMT

The other issue is case-sensitivity. Sorry I missed that earlier. The ID value on the ATTRID option must match the case of the ID value in the ATTRMAP data set. Incidentally, We have added a couple of new columns to the ATTRMAP data set for SAS 9.4m3. One of those columns gives you the ability to turn off case-sensitivity.

Re: Change default colors in SGPLOT

Forecaster — Fri, 06 Mar 2015 19:38:18 GMT

@DanH for some reason, I'm still not getting the right colors. I have changed the codes for easy replicability.

I'm running this code on SAS 9.3 (TS1M2)

data sales;

input product $ actual predict;

datalines;

A 10 5

B 12 15

C 15 18

D 13 20

;

run;

data attrs;

input id $ value $ fillcolor $;

datalines;

actual A blue

actual B black

actual C green

actual D yellow

;

run;

proc sgplot data = sales dattrmap=attrs;

hbar product /response = actual barwidth=0.5 attrid=actual;

hbar product /response=predict barwidth=0.2 ;

run;

Re: Change default colors in SGPLOT

DanH_sas — Fri, 06 Mar 2015 20:00:50 GMT

Sorry, I overlooked that you are not using a GROUP variable. Attrmaps only work when there is a GROUP active. For your example, you just need to use FILLATTRS=(color=<some color>) to control the color of the bars.