When I attempt to add client count into the table I get the following error: WARNING: A table has been extended with null columns to perform the UNION set operation. Do you know why I am getting this error? proc sql;
create table want as
select state,' '||put(pint,best8. -l) as pint length=80,year,put(sum(cost),dollar32. -l) as cost length=80,put(sum(Clients),comma10. -l) as Clients length=80
from have
group by state,pint,year
union
select state,' Subtotal',year,put(sum(cost),dollar32. -l) as cost
from have
group by state,year
union
select state,' Subtotal',year,put(sum(Clients),comma10. -l) as Clients
from have
group by state,year
union
select state,'Completion Factor',year,put((select sum(cost) from have where state=a.state and year=a.year and pint=1)/sum(cost),percent8.2 -l) as cost
from have as a
group by state,year
;
quit;
... View more