calculate percentage with multiple rows

[vraj1]

I have 2 datsets one with s_D_1, s_D_2, s_D_3, s_D_4, s_F_1, s_F_2, s_F_3, s_F_4 and the other dataset has variables n_D and n_F

I need to merge them and calculate precentages with 

= 100*(s/n). for both D and F.

Can any one help me in this

[RW9 · Accepted solution]

Your life would be much easier if you normalised your data, i.e. have something like:

S_D  RESULT

1      abc

2      def

...

Further processing of the data would be easier, and this task would be a simple merge and one calculation step.  With your transposed dataset, you will need to use arrays, and the code thus becomes a bit more complicated - not to mention further coding will be harder.  As you have not provided test data (in the form of a datastep) this code is untested:

data want;
  merge base other;  /* Assumes both are sorted by the id variables */
  by <id variables>;  /* update this row with the matching variables in each dataset */
  array s_d_{4};
  array s_f_{4};
  array s_d_results{4};
  array s_f_results{4};
  do i=1 to 4;
    s_d_results{i}=(s_d_{i} / n_d) * 100;
    s_f_results{i}=(s_f_{i} / n_f) * 100;
  end;
run;
 

Again though, far easier to normalise your data.