Hi @CollinIsmael
Here is an approach using proc sql and an UPDATE statement:
data have;
infile datalines dlm="09"x dsd;
input v1:$20.;
datalines;
"19 (21) 95%"
;
run;
data wanted;
infile datalines dlm="09"x dsd;
input Category:$50. N1:$50. N2:$50. Overall:$50.;
datalines;
group 1 10 (11) 50% 5 (5) 50% 15 (16) 75%
group 2 2 (2) 10% 2 (3) 20% 4 (5) 20%
Total 12 (13) 60% 7 (8) 70%
;
run;
proc print data=wanted;
proc sql;
update wanted
set Overall = (select v1 from have)
where Category="Total";
run;
proc print data=wanted;
Another approach could be to use an UPDATE statement in a DATA step:
data have;
infile datalines dlm="09"x dsd;
input v1:$20.;
datalines;
"19 (21) 95%"
;
run;
data wanted;
infile datalines dlm="09"x dsd;
input Category:$50. N1:$50. N2:$50. Overall:$50.;
datalines;
group 1 10 (11) 50% 5 (5) 50% 15 (16) 75%
group 2 2 (2) 10% 2 (3) 20% 4 (5) 20%
Total 12 (13) 60% 7 (8) 70%
;
run;
data have2;
set have;
Category = 'Total';
rename V1=Overall;
run;
proc sort data=wanted;
by Category;
run;
data wanted;
update wanted have2;
by Category;
run;
Best,
... View more
