adding across columns with conditions

[yoyong555]

Hi all.

My data looks like the one below. 

Resp = name of person

Proc_done = x, if procedure is accomplished .

I would like to add the x's for each person.

Resp       Proc_done      Proc_done_2         Proc_done_3

A                    x                           x

A                    x

B                    x                     

C                    x                           x

C                    x                           x                            x

D                    x                           x

E                    x

E                    x                           x

F                    x

G                   x                            x                            x

The output should look like: 

Resp      nProc_done

A                  3

B                  1

C                  6

D                  2

E                  3

F                  1

G                  3

Thank you in advance.

[ChrisNZ]

Like this?

 NBPROC=count(catt(of PROC_DONE:), 'x');

[ScottBass]

Edit your post using a self-contained data step using datalines, instead of forcing me to convert your cut-and-paste job into a data step.

I'll then answer your question.

[ErikLund_Jensen]

Hi @yoyong555 

PLEASE post your input data as code to create a have-data set, so we have something to work on!

As always, there are several ways of doing things in SAS, here is a Proc SQL solution and a Data Step solution. The output is the same, but the data step requires the input to be sorted on Resp, this is not necessary with proc sql.

proc sql;
	create table want as 
		select 
			Resp,
			sum(sum(Proc_done='x',Proc_done_2='x',Proc_done_3='x')) as nProc_done
		from have
		group by Resp;
quit;

data want2(keep=Resp nProc_done); set have; by resp;
	retain nProc_done;
	if first.Resp then nProc_done = 0;
	nProc_done = sum(nProc_done,Proc_done='x',Proc_done_2='x',Proc_done_3='x');
	if last.Resp then output;
run;