topic Re: Creating Duplicating Records based on column values in SAS Procedures

Creating Duplicating Records based on column values

Siddharth123 — Tue, 05 Apr 2016 08:44:10 GMT

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 c

Any help will be much appreciated.

Kind regards

Re: Creating Duplicating Records based on column values

RW9 — Tue, 05 Apr 2016 09:11:11 GMT

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;

Re: Creating Duplicating Records based on column values

Ksharp — Tue, 05 Apr 2016 09:19:56 GMT

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;