Hi Proc Me,
I have submited the following code
proc sql;
create table brookfr
as
select lname, pcode, fname,sum(brfr.beatles1) as bbeat,sum(brfr.bmalone1) as bmalone,
sum(brfr.bombedout1) as bombout,sum(brfr.confusions1) as confuse,sum(brfr.daveorch1)as dave
from
(
select lname,pcode,fname,count(*) as bbeat,0 as bmalone, 0 as bombout,0 as confuse,0 as dave
from brfr.bbeatles1
group by lname, pcode, fname
union
select lname,pcode,fname,0 as bbeat,count(*) as bmalone,0 as bombout,0 as confuse,0 as dave
from brfr.bmalone1
group by lname, pcode, fname
union
select lname,pcode,fname,0 as bbeat,0 as bmalone, count(*) as bombout,0 as confuse,0 as dave
from brfr.bombedout1
group by lname,pcode,fname
union
select lname,pcode,fname,0 as bbeat,0 as bmalone,0 as bombout,count(*) as confuse,0 as dave
from brfr.confusions1
group by lname,pcode,fname
union
select lname,pcode,fname,0 as bbeat,0 as bmalone,0 as bombedout,0 as confuse,count(*) as dave
from brfr.daveorch1
group by lname,pcode,fname
)
group by lname,pcode,fname
;
quit;
AND I AM GETTING THE FOLLOWING ERROR
look_ds: what's on FROM clause?
ERROR: Unresolved reference to table/correlation name brfr.
look_ds: what's on FROM clause?
ERROR: Unresolved reference to table/correlation name brfr.
look_ds: what's on FROM clause?
ERROR: Unresolved reference to table/correlation name brfr.
look_ds: what's on FROM clause?
ERROR: Unresolved reference to table/correlation name brfr.
look_ds: what's on FROM clause?
ERROR: Unresolved reference to table/correlation name brfr.
ERROR: The SUM summary function requires a numeric argument.
ERROR: The SUM summary function requires a numeric argument.
ERROR: The SUM summary function requires a numeric argument.
ERROR: The SUM summary function requires a numeric argument.
ERROR: The SUM summary function requires a numeric argument.