如何将x不同取值的个数放入macro中

1. data a;
   
2. input x y;
   
3. cards;
   
4. 1 2
   
5. 1 1
   
6. 1 1
   
7. 2 2
   
8. 2 2
   
9. 1 3
   
10. ;
    
11. run;

复制代码

如何将x不同取值的个数放入macro中？谢谢！x为2， y为3。

proc sql noprint;
  select distinct count(distinct x),count(distinct y) into : xnum, : ynum
  from a;
quit;

%put &xnum  &ynum;

pobel 发表于 2013-12-3 12:38
proc sql noprint;
  select distinct count(distinct x),count(distinct y) into : xnum, : ynum
  from ...

the first distinct is redundant.

proc sql noprint;
  select count(distinct x),count(distinct y) into : xnum, : ynum
  from a;
quit;