Hi All,   I run below code to extract all the numeric columns and name them temp_1, temp_2, temp_3 and so on. But I noticed that it does not output all the columns but the last one only. Beside that, temp_&b. is not working at first iteration, it outputs an error.   Can you help solve this? Thanks.   The code:   data new; set work.test; b=1; array vars _numeric_; do i=1 to 10; call symputX('b',b); temp_&b. = vars[i]; b = symget('b')+1; call symputX('b',b); c=i; end; run; ... View more

Hello All,   I try to distinguish some variables whether they are succesful or not. To do this I wrote the below macro but it does not work. flag_&var_used. is not accepted as a variable name in SAS. I also do not get any result neither. I am stuck in this macro.   Help appreciated,   Thanks   %macro success(); %let nitems = %sysfunc(countw(&var_list)); %do i=1 %to &nitems; %let var_used = %scan((&var_list),&i,'|'); %if (&var_used ne 'VAR1' or &var_used ne 'VAR2' or &var_used ne 'VAR3') %then %do; data new_&i.; set old; if &var_used gt 0.01 then flag_&var_used. = 'succesful'; else flag_&var_used. = 'unsuccessful'; run; %end; %end; %mend; ... View more