Hello,
Can you post an example of have and want datasets ?
Edit: removed useless test from previous attempt.
data variables;
input event_name $20. variable $20.;
cards;
CG Version first_cg_scared
CG Version last_cg_scared
CG Version first_cg_fun
CG Version last_cg_fun
Adult Version first_adult_helpless
Adult Version last_adult_helpless
Adult Version first_adult_worthless
Adult Version last_adult_worthless
Pediatric Version first_ped_felt_scared
Pediatric Version last_ped_felt_scared
Pediatric Version first_ped_nervous
Pediatric Version last_ped_nervous
;
run;
data first_last_d;
input event_name $20. first_cg_scared last_cg_scared first_cg_fun last_cg_fun;
cards;
CG Version 1 2 3 4
CG Version 5 6 7 8
;
run;
proc sort data=variables;
by event_name;
run;
data _NULL_;
merge first_last_d (obs=1 keep=event_name in=infld) variables;
by event_name;
if infld then do;
if first.event_name then call execute(cat('proc sql; create table final as select sum(',variable,') as ', variable));
else call execute(cat(', sum(',variable,') as ', variable));
if last.event_name then call execute('from first_last_d; quit;');
end;
run;
... View more
