Hi there,
I have 12 numeric variables (values of either 0,1,2) an am hoping to create a single variable which counts the number of "1"s or "2"s across rows (I have over 20 000 obs); e.g. how many 2s or 1s are in each row/record (rows can have both 1 or 2 - so wont be able to divide out) - I know there must be a simple way of doing this but haven't had much luck yet - any help would be greatly appreciated? Thanks so much!
Have you tried an array and do loop or are you looking for something different?
array vars(12) var1-var12;
var_count=0;
do i=1 to dim(vars);
if vars(i) in (1,2) then var_count+1;
end;
Peek?
Another one ,
data countc;
set have;
array v v1-v12;
ctof12=countc(cats(of v(*)),'12');
run;
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.