logic question

Reply
Occasional Contributor
Posts: 14

logic question

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

Regular Contributor
Posts: 165

Re: logic question

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.

Super Contributor
Posts: 305

Re: logic question

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;

Ask a Question
Discussion stats
  • 2 replies
  • 161 views
  • 0 likes
  • 3 in conversation