sas - Getting error while i create a prompt -


i need create prompt. created 2 no problem, 1 of variable different while creating prompt. needed macro 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 = %eval(&i+1);     %let p_lst_tmp = %scan(&vid,&i);        %end;          %put list_selected = &list_selected;           %mend; 

then in code created

  proc sql;   create table student_pre   select  t1.personid label="pidm" pidm,       t1.v_id vid,           t1.first_name   enroll.student_dim t1  t1.v_id = &list_selected   order t1.personid;    quit; 

but code gives error, error 22-322: syntax error, expecting 1 of 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 ignored.

how should change code?


Comments

Popular posts from this blog

commonjs - How to write a typescript definition file for a node module that exports a function? -

openid - Okta: Failed to get authorization code through API call -

ios - Change Storyboard View using Seague -