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
Post a Comment