calculate percentage with multiple rows

vraj1 — Mon, 04 Apr 2016 07:53:10 GMT

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

Re: calculate percentage with multiple rows

RW9 — Mon, 04 Apr 2016 08:16:15 GMT

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.

topic calculate percentage with multiple rows in SAS Programming

calculate percentage with multiple rows

Re: calculate percentage with multiple rows