Hi,   I have a dataset with two columns like the following:   data temp; input item count; datalines; a1   n1 a2   n2 a3   n3 ... ak   nk ; run;   Basically, {n1, n2, ...,n k} are the counts of {a1,... ak}. I would like to compute the number b= (n1*n2 + n1*n3+ ... +n1*nk) + (n2*n3 + n2*n4+...n2*nk) + ...+ (n_(k-1) *nk). Is there any efficient way to do it?   Thanks.       ... View more

%let mvarlist=A B C D; The SAS data set temp has two variables Var1 and Var2 with four observations. The goal is to assgin A, B, C, D in mvarlist to a new sas variable Var3 in temp1 data so that Var3 has A, B, C, and D for its 4 observations repectively. data temp1; set temp; Var3=%scan(&mvarlist, _N_, ' '); run; (1) I know the above argument _N_ in %scan() is not right since it need a number, not a sas variable. How to achieve the desired result? (2) proc sql has a way to output a sas variable column to a macro var list, is there a way to do the opposite: write a macro list to a sas variable? (3) What if mvarlist=1 2 3 4, I want to input it as a numeric SAS variable? Thanks. ... View more

I have defined macro variables nclass, n0, n1, ..., n&nclass, and response, then I have the following code: proc sql undo_policy=none;   create table temp as   select *,          case            %do k=1 %to &nclass;                when &n%eval(&k-1) le myvar le &&n&k then %scan(&response,&k," ")            %end;               else .             end as RC   from temp; quit; The problem with the above code is: &n%eval(&k-1), there is no problem with &&n&k. Basically it evaluates &n then combine with 0 when k=1. If n is not defined, then it will have unresolved macro variable N problem; if n is defined as 357, for instance, then it will give 3570 for &n%eval(&k-1) when k=1. What I really want is the value of macro variable n0.  Even when I use &&n%eval(&k-1), it still does not work. How can I represent the value of n0 when k=1? ... View more