I'm trying to do something like this, but I'm not sure if you can nest statements PROC SQL;
INSERT INTO table1 (type, MONEY)
VALUES("CD", SELECT sum(money) from table2)
;
QUIT; But I get this error PROC SQL;
183 INSERT INTO race_sjc_mph_data (race, dose_1_num)
184 VALUES("Other Race/ Unknown", SELECT sum(dose_1_num) from race_unknown_other)
______
22
76
ERROR 22-322: Syntax error, expecting one of the following: a quoted string, a numeric constant, a datetime constant,
a missing value, ), +, ',', -, MISSING, NULL, USER.
ERROR 76-322: Syntax error, statement will be ignored. * Notice the variables and tables are name differently. I wanted to be clear with my question *
... View more