Getting error while i create a prompt

Vote count:

0

I need to create a prompt. Actually I created another two with no problem, but one of the variable is different while I was creating prompt. I needed to do macro with that as below:

         %macro param_list;
            %global
    list_selected
    ;
     %let i=1;
     %let p_lst_tmp = %scan(&VID,&i);
      %do %while(&p_lst_tmp ne);
    %let list_selected = &list_selected "%scan(&VID,&i)";
    %let i = %eval(&i+1);
    %let p_lst_tmp = %scan(&VID,&i);
       %end; 
        %put list_selected = &list_selected;
          %mend;

Then in the code I created

  PROC SQL;
  CREATE TABLE Student_Pre AS
  SELECT  t1.personid LABEL="PIDM" AS PIDM,
      t1.V_ID as VID,
          t1.FIRST_NAME
  FROM ENROLL.Student_Dim t1
 WHERE t1.v_id = &list_selected
  ORDER BY t1.personid;
   QUIT;

But this code gives an error, ERROR 22-322: Syntax error, expecting one of the following: ;, !, !!, &, (, , *, +, -, '.', /, <, <=, <>, =, >, >=, AND, EQ, EQT, EXCEPT, GE, GET, GROUP, GT, GTT, HAVING, INTERSECT, LE, LET, LT, LTT, NE, NET, NOT, OR, ORDER, OUTER, UNION, ^, ^=, |, ||, ~, ~=.

ERROR 76-322: Syntax error, statement will be ignored.

How should I change the code?

asked 52 secs ago

user3489870

28