trying to do calculations off of a built table in SAS

[Jyuen204]

I have a table built with integer values (Table X)

Column 1  Column 2
A               1

B               2

C               10

I have a secondary table (Table Y) built with Decimal variables to contain a calculated number based on Table X

proc sql;

(select sum(Column 2) from Table X where  Column 1 like ('A', 'B') ) /

(select Column 2 from Table X where Column 1 = 'C');

Run;

I am trying to run this calculation but am getting an error

ERROR 22-322: Syntax error, expecting one of the following: ;, EXCEPT, INTERSECT, ORDER, OUTER, UNION.

[PaigeMiller]

Although you mention you have table Y, it doesn't seem to appear in your description of the problem.

Where does it come into use?

[Jyuen204]

I am going to be insterting the caluclated value into Table Y. I suppose it's not relevant here because my issue is the calculation part.

[PaigeMiller]

Show us the log of this PROC SQL step. We need to see the entire LOG, not just the error message. To preserve the formatting and make the log readable, please click on the {i} icon and paste the log into the window that appears — do not skip this step.

[PGStats]

Proper syntax could be:

proc sql;
create table Y as
	sum((column1 like ('A', 'B'))*Column2) / 
	sum((column1 = 'C')*Column2) as Ratio
from X;
quit;

[FreelanceReinh]

Or try the third step of this example:

data X;
input Column1 $ Column2;
cards;
A 1
B 2
C 10
;

proc sql;
create table Y (z num);
quit;

proc sql;
insert into Y
select
(select sum(Column2) from X where Column1 in ('A', 'B')) / Column2
from X where Column1 = 'C';
quit;