topic Re: Populate first column name in New SAS User

Populate first column name

SASPhile — Mon, 15 Apr 2019 03:48:57 GMT

There is a table with below data structrue:

id aesoc aeterm Count
1 Heart Atrial fibrillation 25
1 Heart Cardiac arrest 27

2 Ear Deafness 10

2 Ear Ear Pain 5

Need help in adding the value of aesoc to aterm so all the records that belong to heart will be under under one column.

id aeterm Count rec_add
1 Heart 42 Y
1 Atrial fibrillation 25
1 Cardiac arrest 27

2 Ear 15 Y

2 Deafness 10

3 Ear Pain 5

Re: Populate first column name

PeterClemmensen — Mon, 15 Apr 2019 07:10:19 GMT

There you go

data have;
input id aesoc $ aeterm :$30. Count;
infile datalines dlm=',';
datalines;
1,Heart,Atrial fibrillation,25
1,Heart,Cardiac arrest,27
2,Ear,Deafness,10
2,Ear,Ear Pain,5
;

data want(drop=sum);

   do until (last.id);
      set have;
      by id;
      sum=sum(sum, count);
   end;

   Count=sum;aeterm=aesoc;rec_add='Y';
   output;
   rec_add='';

   do until (last.id);
      set have;
      by id;
      output;
   end;

run;