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

nitink26 — Sun, 26 Feb 2023 10:04:11 GMT

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.

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

Patrick — Sun, 26 Feb 2023 12:26:18 GMT

Please don't ask the same question twice.

nitink26 — Mon, 27 Feb 2023 03:21:40 GMT

Pls find solution here -