## proc tabulate and filtering unique colum value

Solved
Frequent Contributor
Posts: 84

# proc tabulate and filtering unique colum value

I have a proc tab that does a count as the default statistic

proc tabulate data=WORK.HRIR99991 missing contents = ' '  S=[foreground=highlight.];
var fte;
keylabel Sum = " ";

contents = ' ' misstext=' ' box={label="&boxlabel"};

RUN;

this gives ne a count of the number of records in the data set however each record has an employees HR ID number in it  (called HRID)

what I would like to do is just count each unique HRID once to get a head count is tehre a way to do that in proc tab?

Accepted Solutions
Solution
‎12-01-2015 02:36 PM
Super User
Posts: 13,583

## Re: proc tabulate and filtering unique colum value

If your HRID varialbe is actually numeric you could make it a VAR variable and ask for the N statistic. That gives a count. When it is a CLASS variable then you get the individual values. But VAR must be numeric not a character variable containing digits.

All Replies
Super User
Posts: 23,778

## Re: proc tabulate and filtering unique colum value

Unfortunately, proc tabulate cannot generate unique counts

Depending on what your'e doing you can consider adding a 1 to the first record and the remaining as 0 and then sum that field, but if you're cross tabbing data that won't always work because you need to count by groups.
Solution
‎12-01-2015 02:36 PM
Super User
Posts: 13,583

## Re: proc tabulate and filtering unique colum value

If your HRID varialbe is actually numeric you could make it a VAR variable and ask for the N statistic. That gives a count. When it is a CLASS variable then you get the individual values. But VAR must be numeric not a character variable containing digits.

Occasional Contributor
Posts: 11

## Re: proc tabulate and filtering unique colum value

I wonder why and incorrect answer is marked as a solution.  N gives a count, but not a unique count.

☑ This topic is solved.

Discussion stats
• 3 replies
• 1006 views
• 0 likes
• 4 in conversation