Nothing simple, and nothing pretty. I guess I would use CALL EXECUTE in that DATA step to generate the proper PROC DATASETS statements to assign labels. In real life, does the data set already exist in SAS form (and you need to change the labels)?  Or are you really inputting from raw data?  I guess my approach could work either way, but it does get messy. ... View more

Shouldn't the final assignment be rearranged? y{i} = vlabel(x{i}); ... View more

Depending on your requirements. a simple PROC TABULATE may do the job.  How are your requirements different than this: proc format; value gender 0='male' 1='female'; run; proc tabulate data=have;    class gender agegrp;    tables gender agegrp, N PctN;    format gender gender.; run; I realize you may have lots of answers, and really want to change the output.  But how far apart is this from what you need? ... View more

tom, The syntax is right.  Let me put it in context for you, again using just 3 variables.  I'm not saying this is the fastest way, but it is easy to program (expecially if you don't have SAS/OR).  Here's the final generated program for N=3: data solutions;    do v1=0 to 100 by 10;        do v2=0 to 100 by 10;            do v3 = 0 to 100 by 10;                if sum(of v1-v3)=100 then output;            end;        end;    end; run; So this doesn't try to reduce the number of permutations in any way.  A more full-blown macro would let you pass a value for &N.  Maybe you can picture this using N=3, and compare it to the code above: %macro add_to_100 (N); data solutions; %local i; %do i=1 %to &N; do v&i = 0 to 100 by 10; %end; if sum(of v1-v&N) = 100 then output; %do i=1 %o &N; end; %end; run; %mend add_to_100; I know you have a solution ... I'm just dotting the i's and crossing the t's here. ... View more

ZRick, PUT can write text strings, as well as values found in the DATA step variables. %PUT can write text strings only (including the values of macro variables), NEVER the contents of a DATA step.  You might utilize other tools such as CALL SYMPUT to transfer information from a DATA step to a macro variable.  After that, %PUT can write the macro variable's value. Good luck. ... View more

tom, If I understand the problem correctly this time, you always want to get the sum of all N variables.  That's relatively easy for a macro to generate, but as you have noted it may involve a great number of combinations. Assuming you have a parameter &N with the number of variables, this belongs inside a macro definition: %local i; %do i=1 %to &N; do v&i = 0 to 100 by 10; %end; if sum (of v1-v&N)=100 then output; %do i=1 %to &N; end; %end; Good luck. ... View more

Linus, I've seen something like this as a real-life problem.  Given up to 20 recent transactions, find any combinations that sum to 0.  The idea is that some transactions may be refunds for a combination of other purchases.  You need to match the refund to the purchases. At any rate, here's an approach simplified for 3 variables.  The idea is to find combinations of v1-v3 that sum to 100. do in1 = 'OUT', 'IN';    do in2 = 'OUT', 'IN';       do in3 = 'OUT', 'IN';           total = v1 * (in1='IN') + v2 * (in2='IN') + v3 * (in3='IN');           if total=100 then output;       end;    end; end; You can always switch to arrays if the number of variables becomes large.  But note that your program canl chug for a while as the number of variables increases. If you have to, you can always place this code inside a set of loops like this: do v1=0 to 100 by 10;    do v2=0 to 100 by 10;       do v3=0 to 100 by 10;     ** Above code;       end;    end; end; I'm just not certain whether this is part of the problem though. Good luck! ... View more

Linlin, Perfect.  Thank you! OK, I thought the next step would be easy.  But somehow I'm not seeing it ... What do I need to click on to mark your answer as Correct?    :smileyshocked: OK, figured it out.  :smileylaugh:  .,.. I hope! ... View more