Yes, except I would also like to use a group by clause somewhere in there. (sorry if I didn't mention it initially) So, on the actual output table or view, I would like to group the a/b based on each program area, and there are about 20 program areas and I don't want to do this 20 times. Will it be.... proc sql; create table as resultSet as select ProgramAreas, sum(sex='M') as a, count(*) as b, calculated a/calculated b as c from table group by Program Areas; run; Will this run without errors?
... View more