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.
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;
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.
ones = count(stringvar,'1');
should do it
Bingo - I knew there would be something simple!
Thanks.
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.
Ready to level-up your skills? Choose your own adventure.