Thank you and yes, the columns are numeric variables with possible values of 1, 2, 6 & 7 with 1=Yes, 2=No etc. and I wanted to count the 1s Something like this: count of "1" ID Col1 Col2 Col3 Col4 Col5 Col6 Col7 Col8................WANT 152 1 0 1 0 1 9 1 7 4 153 0 0 7 7 1 9 0 9 1 154 1 9 1 9 9 0 0 9 2 155 7 1 9 1 9 1 1 9 4 156 9 0 0 9 0 0 0 0 0 157 9 7 9 0 7 1 0 0 1 I found this in another thread which helped data want;
set have;
countval = countc(cats(of col1-col13),'1');
run; Thanks again
... View more