topic Re: Summay a binary flag field in SAS Procedures

Summay a binary flag field

OS2Rules — Wed, 22 Oct 2014 15:05:00 GMT

Hi All:

Quick question: I have a 19 byte character field that contains only '0's and '1's. Is there a quick (simple) way to sum the numerals in the field

to see how many of them are set to '1'. This way if the sum is > 1 I know there is more than 1 byte not 'zero'. Unfortunately, the field is a

character field and I can't change that.

Thanks in advance.

stat_sas — Wed, 22 Oct 2014 15:23:32 GMT

data have;
input var $ 19.;
datalines;
0
0
1
1
0
1
0
0
;

data want(keep=cnt_one);
set have end=eof;
if strip(var)='1' then cnt_one+1;
if eof then output;
run;

OS2Rules — Wed, 22 Oct 2014 15:26:45 GMT

Hi:

The data is in a variable formatted like: '0001001000110001000' and I basically need to count the number of '1's.

I could use an array but that is messy. Hoping for something simple.

Thanks.

ballardw — Wed, 22 Oct 2014 15:28:26 GMT

ones = count(stringvar,'1');

should do it

OS2Rules — Wed, 22 Oct 2014 15:47:43 GMT

Bingo - I knew there would be something simple!

Thanks.