topic Re: adding across columns with conditions in SAS Programming

adding across columns with conditions

yoyong555 — Tue, 04 Jun 2019 01:35:09 GMT

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.

Re: adding across columns with conditions

ChrisNZ — Tue, 04 Jun 2019 23:37:47 GMT

Like this?

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

Re: adding across columns with conditions

ScottBass — Wed, 05 Jun 2019 01:54:31 GMT

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.

Re: adding across columns with conditions

ErikLund_Jensen — Wed, 05 Jun 2019 08:59:20 GMT

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;