Hi,
I would like to know the equivalent of proc sql count distinct operation.
I want to count the number of contrats and the number of people in a dataset but for my purpose i want to do it in a proc report (if possible).
So i have id_contrat and id_person that are non numeric variables and i only managed to calculate the number of contrats corresponding to the number of observations. I don't want to display each id_contrat nor id_person.
I did this so far :
proc report data = a ;
columns ('Perimeter' var_to_group_by n) ;
define var_to_group_by / group ;
define n / 'nb_contracts' ;
run ;
Thanks