topic Re: dattrmap in SAS Programming

dattrmap

Leo9 — Wed, 10 Mar 2021 20:26:32 GMT

Hi All,

I am creating this dataset below to assign different color to bars based on values.

data barcol ;
length id value fillcolor $50 ;
retain linecolor "black" ;
id = "coht"; value = "1 x 10^7 cells" ; fillcolor = "red" ; output;
id = "coht"; value = "2 x 10^8 cells" ; fillcolor = "green" ; output;
id = "coht"; value = "2 x 10^7 cells" ; fillcolor = "orange" ; output;
run;

Problem is caret sign (^) is causing an issue when I am using it in proc sgplot (see below). I am getting warning message Duplicate values are not permitted in DiscreteAttrMap: 2 x 10 cells.

It seems it is not considering caret sign (^).

proc sgplot data=final noautolegend nocycleattrs dattrmap=barcol;
styleattrs wallcolor = lightyellow ;
highlow y=subj low=start high=end1 / highcap=acap group=coht type=bar nooutline nomissinggroup name = 'proj' attrid = coht ;

Any suggestion on how to make it work? Thanks in advance.

Re: dattrmap

Reeza — Wed, 10 Mar 2021 21:32:10 GMT

Instead of typing out the values, can you get them from your data to avoid the issue? Or try using the ascii code (94) with the BYTE function to get the text as desired.

Maybe this:
value = catt("2 x 10", byte(94), "8 cells";

Re: dattrmap

ballardw — Wed, 10 Mar 2021 21:44:23 GMT

It may be time to actually provide example data.

With some dummy data this "works"

data barcol ;
length id value fillcolor $50 ;
retain linecolor "black" ;
id = "coht"; value = "1 x 10^7 cells" ; fillcolor = "red" ; output;
id = "coht"; value = "2 x 10^8 cells" ; fillcolor = "green" ; output;
id = "coht"; value = "2 x 10^7 cells" ; fillcolor = "orange" ; output;
run;


data plot;
  infile datalines dlm=',' truncover;
  input subj start end1 coht :$14.;
datalines;
1,5,15,1 x 10^7 cells
2,3,12,2 x 10^8 cells 
3,4,18,2 x 10^7 cells
;

proc sgplot data=plot  noautolegend nocycleattrs dattrmap=barcol;
   styleattrs wallcolor = lightyellow ;
   highlow y=subj low=start high=end1 /  group=coht 
   type=bar nooutline nomissinggroup   name = 'proj' attrid = coht ; 
run;

When we say the Value variable has to match the Group variable values you cannot have any difference. From the code you post for the dattrmap set you might have a difference in spaces.

Another potential headache is exactly which character and character set is used for the ^. If one is the programming ^ you get from your keyboard with Shift+6 key that may not be a UNICODE character that looks like it from your data.

Run proc contents on both your dattrmap data set and the data set you are plotting.

In this part of the output:

                                      The CONTENTS Procedure

           Data Set Name        WORK.PLOT                     Observations          3
           Member Type          DATA                          Variables             4
           Engine               V9                            Indexes               0
           Created              03/10/2021 14:38:02           Observation Length    40
           Last Modified        03/10/2021 14:38:02           Deleted Observations  0
           Protection                                         Compressed            NO
           Data Set Type                                      Sorted                NO
           Label
           Data Representation  WINDOWS_64
           Encoding             wlatin1  Western (Windows)

If the text following Encoding is not the same you have different characters sets and the equality becomes problematic.

Re: dattrmap

Leo9 — Tue, 16 Mar 2021 23:42:35 GMT

I tried both solution but none is working

Re: dattrmap

Reeza — Wed, 17 Mar 2021 15:57:58 GMT

Show what you tried.