Creating Duplicating Records based on column values

[Siddharth123]

Hi All,

Could anyone help me in this problem. I have a SAS Dataset created as follows -

Data test;
input Id a b c;
infile datalines;
datalines;
123 20 30 50
124 1 5 8
;
run;

I want to create a new column, say 'Total', which gives me a total count for the columns a, b, c. For example for the Id 124 in table above the SAS output data should give me -

Id      Total

124     a

124     b

 124    b

 124    b

 124    b

 124    b

 124    c

 124    c

 124    c

 124    c

 124    c

 124    c

 124    c

 124    c

Any help will be much appreciated.

Kind regards

SK

[RW9]

Hi,

Something like:

data test;
  input id a b c;
  infile datalines;
datalines;
123 20 30 50
124 1 5 8
;
run;
data want (keep=id total);
  length total $10;
  set test;
  array vars{3} a b c;
  do i=1 to 3;
    do j=1 to vars{i};
      call vname(vars{i},total);
      output;
    end;
  end;
run;

[Ksharp]

Data test;
input Id a b c;
infile datalines;
datalines;
123 20 30 50
124 1 5 8
;
run;
data want;
 set test;
 array x{*} a b c;
do j=1 to dim(x);
 total=vname(x{j});
 do i=1 to x{j};
  output;
 end;
end;
 drop i j a b c;
run;