topic logic question in SAS Programming

logic question

dennis_oz — Wed, 01 Oct 2014 06:16:37 GMT

Hi,

I have a dataset like below

name indicator1 indicator2 indicator3 indicator4 - --- indicator65

danny 1 . 1 1 .

danny . 1 . . . 1

danny 1 1 1 1 1

sam 1 . . . .

sam 1

output

name indicator1 indicator2 indicator3 indicator4 - --- indicator65

danny 1 1 1 1 .

sam 1 . . . .

please help

Re: logic question

RamKumar — Wed, 01 Oct 2014 06:58:15 GMT

Try this,

data trans;

input Name $ Field1-Field5 ;

cards;

danny 1 . 2 3 .

danny . 4 . 3 5

sam . 4 . 4 5

sam 1 . 2 4 .

;;;;

run;

data flat;

update trans(obs=0) trans;

by Name;

run;

proc print;

run;

I seen a similar post yesterday in this forum as well.

Re: logic question

Loko — Wed, 01 Oct 2014 07:37:36 GMT

Hello,

Another solution:

data have;

input name $ indicator1 indicator2 indicator3 indicator4 indicator5;

datalines;

danny 1 . 1 1 .

danny . 1 . . 1

danny 1 1 1 1 1

sam 1 . . . .

sam . . . . 1

;

proc means data=have nway ;

var indicator1-indicator5;

class name;

output out=want (drop=_type_ _freq_) max=;

run;