Are these Train value unique ?
data have ;
input Train $ Current Landing In_Line In_Tankage ;
cards;
Singles 3 3 2 .
Doubles 9 8 1 4
Triples 4 4 . .
6 4 3 . .
7 . . . 1
8 . . 1 .
;;;;
run;
proc sql;
create table want as
select * from have where anyalpha(Train)
union all
select "Quad+" as Train,sum(Current) as Current,sum(Landing) as Landing,sum(In_Line) as In_Line,sum(In_Line) as In_Line
from have
where anydigit(Train);
quit;
Xia Keshan
... View more
