Need help to create proc report using multiple values in one column

[nitink26]

Hi,

Code - 

%macro aa;
%do I = 1 %to 4;
PROC SQL NOPRINT ;
SELECT ID INTO : ITEM FROM TEST
WHERE N = &I.;
QUIT;

PROC SQL NOPRINT ;
SELECT VALUES INTO : other_items FROM TEST
WHERE N = &I.;
QUIT;

%PUT &ITEM. &other_items.;
proc report data=TEST;
column ID A1-A7 VALUES;

compute A1;
IF ID = &item. and A1 IN &other_items.
THEN call define('A1', "style", "style=[background=lightgreen]");
endcomp;

compute A2;
IF ID = &item. and A2 IN &other_items.
then call define('A2', "style", "style=[background=lightgreen]");
endcomp;

compute A3;
IF ID = &item. and A3 IN &other_items.
then call define('A3', "style", "style=[background=lightgreen]");
endcomp;

compute A4;
IF ID = &item. and A4 IN &other_items.
then call define('A4', "style", "style=[background=lightgreen]");
endcomp;

compute A5;
IF ID = &item. and A5 IN &other_items.
then call define('A5', "style", "style=[background=lightgreen]");
endcomp;

compute A6;
IF ID = &item. and A6 IN &other_items.
then call define('A6', "style", "style=[background=lightgreen]");
endcomp;

compute A7;
IF ID = &item. and A7 IN &other_items.
then call define('A7', "style", "style=[background=lightgreen]");
endcomp;
%END;
%mend;
%AA;

run;

output from above code- 

Output I need -

I need output on the basis of id and VALUES column and highlight the cells A1-A7 according to values in column VALUES. 

Here ID is a unique identifier and one ID has only one unique value in VALUES column.

Dataset test is attached for your reference.

[Patrick · Accepted solution]

Please don't ask the same question twice. 

Discussion with answers here: https://communities.sas.com/t5/SAS-Programming/I-need-to-colour-columns-values-while-sending-to-exce... 

[nitink26]

Pls find solution here -

https://communities.sas.com/t5/SAS-Programming/I-need-to-colour-columns-values-while-sending-to-exce...