Store distinct count in macro variable

[noobs]

Hello EG Users,

How can one store value that represents distinct rows of a variable in dataset into macro?

Data have;

Week   Activity

5          Pingpong

10          Badminton

15          Chess

I would like to count distinct values for Week, which is 3 in this case and store it in macro Week_Distinct.

I would appreciate your instructions on how to achieve that?

Regards,

Dhanashree

[PaigeMiller]

untested code

proc sql noprint;

    select distinct(week) into :week_distinct from have;

quit;

[pradeepalankar]

hi,

correct sql should be:

Data have;

input Week Activity :$;

cards;

5 Pingpong

10 Badminton

15 Chess

;

proc sql ;

select  count(distinct week) into :week_distinct from have;

quit;

238  %put &week_distinct;

3

[noobs]

Thanks!

[amitr4620]

How to store no of row in a variable without processing sql