If the data like the following,
a=1, 2, 3, 4 b=1, 2, 3, 4 c=1, 2, 3, 4.
if a=1 or b=1 or c=1 then d1=1; else d1=0;
if a=2 or b=2 or c=2 then d2=1; else d2=0;
if a=3 or b=3 or c=3 then d3=1; else d3=0;
if a=4 or b=4 or c=4 then d4=1; else d4=0;
So how to make the programs easier by Macro.
No macro needed, use arrays and a DO loop:
data want;
set have;
array in {*} a b c;
array out {*} d1-d4;
do i = 1 to dim(out);
out{i} = (whichn(i,of in{*}) > 0);
end;
drop i;
run;
No macro needed, use arrays and a DO loop:
data want;
set have;
array in {*} a b c;
array out {*} d1-d4;
do i = 1 to dim(out);
out{i} = (whichn(i,of in{*}) > 0);
end;
drop i;
run;
Thank you so much!
It works.
You really only need the one macro.
out{i} = (whichn(i,of a b c) > 0)
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.