Hi, I tried the below codes but the last part didn't work, syntax errors showing as below.
Can anyone advise on it?
Thanks
DATA GROUP;
INPUT GROUP$ SUBGROUP$ UNIT$;
CARDS;
GROUP1 SUBGROUP1 UNIT1
GROUP1 SUBGROUP2 UNIT1
GROUP1 SUBGROUP3 UNIT3
GROUP4 SUBGROUP4 UNIT4
GROUP5 SUBGROUP5 UNIT5
;
RUN;
PROC SQL;
SELECT UNIT INTO: UNIT_TEST
SEPARATED BY ' '
FROM GROUP;
QUIT;
%PUT &UNIT_TEST;
/* THIS PART DIDN'T WORK */
PROC SQL;
SELECT
SUBGROUP,
&UNIT_TEST
FROM GROUP
WHERE GROUP = "GROUP1";
QUIT;
40
41 %PUT &UNIT_TEST;
UNIT1 UNIT1 UNIT3 UNIT4 UNIT5
42
43 /* THIS PART DIDN'T WORK */
44 PROC SQL;
45 SELECT
46 SUBGROUP,
47 &UNIT_TEST
48 FROM GROUP
____
22
201
ERROR 22-322: Syntax error, expecting one of the following: a name, ;, (, ',', '.', ANSIMISS, AS, CROSS, EXCEPT, FULL, GROUP,
HAVING, INNER, INTERSECT, JOIN, LEFT, NATURAL, NOMISS, ORDER, OUTER, RIGHT, UNION, WHERE.
ERROR 201-322: The option is not recognized and will be ignored.
NOTE: Line generated by the macro variable "UNIT_TEST".
48 UNIT1 UNIT1 UNIT3 UNIT4 UNIT5
_____
22
202
ERROR 22-322: Syntax error, expecting one of the following: a quoted string, !, !!, &, (, *, **, +, ',', -, '.', /, <, <=, <>, =,
>, >=, ?, AND, AS, BETWEEN, CONTAINS, EQ, EQT, FORMAT, FROM, GE, GET, GT, GTT, IN, INFORMAT, INTO, IS, LABEL, LE,
LEN, LENGTH, LET, LIKE, LT, LTT, NE, NET, NOT, NOTIN, OR, TRANSCODE, ^, ^=, |, ||, ~, ~=.
ERROR 202-322: The option or parameter is not recognized and will be ignored.
49 WHERE GROUP = "GROUP1";
... View more
