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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.