Hi, novinosrin, This didn't seem to work either. This results in the same exact error. create table %scan(&variables.,&i.)_tb as select distinct %scan(%superq(variables),&i.),
_
22
45 ! sum(paid_amount) as paid_amount, paid_date from
45 ! add_descriptions5 group
3 The SAS System 11:41 Wednesday, October 17, 2018
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, a datetime constant,
a missing value, *, BTRIM, INPUT, PUT, SUBSTRING, USER.
NOTE 137-205: Line generated by the invoked macro "table_creator".
45 by %scan(%superq(variables),&i.),paid_date;
_
22
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, a datetime constant,
a missing value, BTRIM, INPUT, PUT, SUBSTRING, USER.
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
NOTE 137-205: Line generated by the invoked macro "table_creator".
45 create table %scan(&variables.,&i.)_tb as select distinct %scan(%superq(variables),&i.),
_
22
45 ! sum(paid_amount) as paid_amount, paid_date from
45 ! add_descriptions5 group
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, a datetime constant,
a missing value, *, BTRIM, INPUT, PUT, SUBSTRING, USER.
NOTE 137-205: Line generated by the invoked macro "table_creator".
45 by %scan(%superq(variables),&i.),paid_date;
_
22
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, a datetime constant,
a missing value, BTRIM, INPUT, PUT, SUBSTRING, USER.
NOTE: The SAS System stopped processing this step because of errors.
... View more