Proc report - COUNT DISTINCT

elsfy — Wed, 11 May 2022 09:06:17 GMT

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

Re: Proc report - COUNT DISTINCT

AMSAS — Wed, 11 May 2022 11:23:20 GMT

Like this?
See REPORT Procedure

data have ;
	do group=1 to 3 ;
		do members=1 to int(ranuni(0)*10) ;
			output ;
		end ;
	end ;
run ;

proc report data=have ;
   column group members ;
   define group/group ;
   define members/analysis n ;

run;

topic Proc report - COUNT DISTINCT in SAS Programming

Proc report - COUNT DISTINCT

Re: Proc report - COUNT DISTINCT