opt_suppress_names.sas

data names_raw;
	infile "C:\Users\dbatten\Desktop\Name Data.csv" dlm = ',' dsd truncover lrecl = 1000;
	
	input first_name :$50. last_name :$50. race :$3. number :5.;
run;
 
proc means noprint data = names_raw;
	class first_name last_name race;
	var number;
 
	output out = names(keep = _type_ first_name last_name race number rename = (_type_ = level)) sum = number;
run;
 
data names;
	set names;
 
	if first_name = ' ' then first_name = 'ALL';
	if last_name = ' ' then last_name = 'ALL';
	if race = ' ' then race = 'ALL';
run;
 
%opt_suppress(names,number,first_name|last_name|race,3);