Hi All ,   I am also getting "  ERROR: The length of the value of the macro variable UNIT_VAR_LIST (65540) exceeds the maximum length (65534). The value has been truncated to 65534 characters."  but when I searched I read about option "mexecsize" which is available to solve this issue but I do not know how to use "mexecsize" option . Can anyone help me on this this issue ? I Have written this code to format all SAS varibles (FORMAT &UNIT_VAR_LIST 9. ; FORMAT &DLLR_VAR_LIST 9.2;)  at once. libname lib '/my/sas/var_size_issue'; *proc options mexecsize=MAX; *run; *MEXECSIZE = MAX; PROC SQL NOPRINT; CREATE TABLE lib.VAR_NAMES AS SELECT NAME FROM DICTIONARY.COLUMNS WHERE libname ='LIB' AND memname ='MGR'; SELECT COMPRESS(NAME) INTO :UNIT_VAR_LIST SEPARATED BY " " FROM lib.VAR_NAMES WHERE UPCASE(name) LIKE '%unit%' OR UPCASE(name) LIKE UPCASE('%UNIT%'); SELECT COMPRESS(NAME) INTO :DLLR_VAR_LIST SEPARATED BY " " FROM lib.VAR_NAMES WHERE UPCASE(name) LIKE '%dllr%' OR UPCASE(name) LIKE '%DLLR%'; QUIT;   ... View more

The column you called "group" in the attrmap must be called "value". It's a reserved column name for the column that contains the values to map. Also, you need the "ID"  column to contain the ID referenced from the plot statement. We do it this way because you can have multiple attrmaps in the same data set. Your code should look something like this:   Data Attrmap; retain id "myid"; /* or whatever you want to call the map */ input value $ fillcolor $8.; datalines; 0 beige 1 pink ; RUN; Proc SGPLOT data=work.Test noborder noautolegend dattrmap=attrmap; Title "Test"; VBAR Date / RESPONSE=Resul group=group attrid=myid; yaxis display=(noline noticks) Label="mm:ss"; RUN; ... View more

Thanks @novinosrin   Works now.   Cheers   Dean ... View more

Just 2 changes to @LinusH: active=ifc(whichc("YES",of active1-active4),"YES","NO"); Binary choices can be simpified with ifc() or ifn(), and whichc will return a numeric at the variable where the string is found.  I have grown to love ifc/ifn  ... View more

Thanks @PeterClemmensen   Works a treat.   Cheers   Dean ... View more

Thanks @BrunoMueller      Works now.   Cheers   Dean ... View more

@ballardw thanks heaps ... View more

Thanks ballardw - works perfectly.   Sorry about the confusion with the dates - I couldn't get the dates in properly in the test data so I used the numeric value instead.   The data comes from SAS tables so the field is set to a date value.   Thanks heaps.   Dean     ... View more

Thanks #ballardw,   Thought I had used the same table but is a different one and yes one date length was 5 and the other was 8.   Will keep Proc Contents in mind for next time.   Cheers   Dean     ... View more

Thanks @Ksharp exactly what I required.   Cheers   Dean ... View more

Untested, but ought to work:   proc sql; select catx(' ', quote(trim(group1)), quote(trim(group2)), quote(trim(group3)), quote(trim(group4)), quote(trim(group5))) into : grouplist separated by ' ' from test; quit; ... View more