Hi all, I have some variables named like this var_1, var_2, var_3.....var_50. Right now it is up to var_50, but anytime if a new case is added to the data, it can be var_51, var_52 etc. So, I use the term var_: when I run frequency or crosstabs to avoid repeated  codes and to avoid writing new codes whenever  a new case is added. But whenever I use 'var_:' in 'if then statement', it does not work. Any suggestion? One thing to mention that var_1 is a neumaric variable but I but similar character variable too (eg. hlt_1, hlt_2, hlt_3 etc.) with which I have the same problem.    here is an example of code that I am using: If var_: in (5) then flag=1; if hlt_: in ('100897') then flag=1;   Thank you! ... View more

*I want to print out any of the tree_: which falls under any of the following types of trees '999', '888' etc.; *The following code I have used; %let trees = %nrstr ('999', '888', '111', '222', '555', '876', '564', '109', '456', '543', '897', '009', '321'); *I will check many more types of trees like the '999' etc.; data want; set have; array hl {*} tree_:; *here tree_: can be even up to 50 (tree_50) and it is not fixed; tree_ = &trees; do i=1 to dim(hl); if hl(i) ne &trees then tree_ = 0; tree = whichc('&trees', of hl(*))>0; end; run; The following is what showing in log, there were some numbers at the beginning of each SAS statement that I have replaced with *** as I am not sure if I can publish it; ****%let trees = %nrstr('999', '888', '111', '222', '555', '876', '564', '109', '456', '543', '897', '009', '321'); **** data want; **** set have; **** array hl {*} tree_:; **** tree_ = &trees; NOTE: Line generated by the macro variable "trees". 1 '999', '888', '111', '222', '555', '876', '564', - 388 - 76 1 ! '456', '543', '897', '009', '321' ERROR 388-185: Expecting an arithmetic operator. ERROR 76-322: Syntax error, statement will be ignored. **** do i=1 to dim(hl); **** if hl(i) ne &trees then tree_ = 0; NOTE: Line generated by the macro variable "trees". 1 '999', '888', '111', '222', '555', '876', '564', - 388 - 76 1 ! '456', '543', '897', '009', '321' ERROR 388-185: Expecting an arithmetic operator. ERROR 76-322: Syntax error, statement will be ignored. **** tree = whichc('&trees', of hl(*))>0; **** end; **** run; NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.want may be incomplete. When this step was stopped there were 0 observations and *** variables. WARNING: Data set WORK.want was not replaced because this step was stopped. NOTE: DATA statement used (Total process time): real time ** seconds cpu time ** seconds *can anyone please suggest what may be the wrong with the code?; ... View more