How to get the desired output

Aayushi_17 — Tue, 07 Jan 2020 06:14:42 GMT

PE	VS	LB	MH	GH
0	1	0	1	0
0	0	1	1	0
0	0	0	0	1
1	1	1	1	1
0	0	0	0	0
0	0	0	0	0

output I want is

VS:MH

LB:MH

PE:VS:LB:MH:GH

values which has 1 to concatenate them.

Thanks in advance

Re: How to get the desired output

PeterClemmensen — Tue, 07 Jan 2020 06:30:35 GMT

One way

data have;
input PE VS LB MH GH;
datalines;
0 1 0 1 0 
0 0 1 1 0 
0 0 0 0 1 
1 1 1 1 1 
0 0 0 0 0 
0 0 0 0 0 
;

data want(keep=v);
    length v $ 200;
    array _{*} PE VS LB MH GH;
    set have;
    v='';
    do i=1 to dim(_);
        if _[i]=1 then v=catx(':', v, vname(_[i]));
    end;
    retain v;
run;

Result:

VS:MH
LB:MH
GH
PE:VS:LB:MH:GH

topic Re: How to get the desired output in SAS Programming

How to get the desired output

Re: How to get the desired output