Need to concatenate duplicate tables but also need to summarize variable:
proc sql;
create table user.nfctape as
select ident,
system,
account,
start_date,
end_date,
sum(ddsusize) as size format 20.5,
hlq
from user.plex_init union corresponding
select ident,
system,
account,
start_date,
end_date,
sum(ddsusize) as size format 20.5,
hlq
from user.test_init
group by ident, system, account, start_date, end_date, hlq;
Is this even possible in one statement? This code runs but the summarization from first table doesn't take account the GROUP BY statement.
... View more