topic Re: Store distinct count in macro variable in SAS Enterprise Guide

Store distinct count in macro variable

noobs — Fri, 21 Mar 2014 19:37:10 GMT

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 — Fri, 21 Mar 2014 19:46:10 GMT

untested code

proc sql noprint;

select distinct(week) into :week_distinct from have;

quit;

pradeepalankar — Sat, 22 Mar 2014 19:27:01 GMT

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;

noobs — Fri, 04 Apr 2014 12:26:46 GMT

Thanks!

amitr4620 — Sun, 25 Nov 2018 16:19:23 GMT

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