Use the prefix= option in Proc Transpose like this
data have;
input ID $ Location $;
datalines;
101 UK
101 France
101 Other
102 UK
102 Spain
103 Other
104 UK
104 Other
105 Other
;
proc transpose data = have out = temp(drop = _:) prefix = m_;
by ID;
id Location;
var Location;
run;
data want;
set temp;
array a m_:;
count = 0;
do over a;
a = ifc(a ne '', 'Y', a);
if a = 'Y' then count + 1;
end;
run;
... View more
