topic Re: proc tabulate and filtering unique colum value in SAS Procedures

proc tabulate and filtering unique colum value

robm — Tue, 01 Dec 2015 15:45:57 GMT

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

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

   table BUSINESS_UNIT_DESC='Business Unit' * N='Record Count'/
                  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?

Re: proc tabulate and filtering unique colum value

Reeza — Tue, 01 Dec 2015 16:12:51 GMT

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.

Re: proc tabulate and filtering unique colum value

ballardw — Tue, 01 Dec 2015 16:18:19 GMT

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.

Re: proc tabulate and filtering unique colum value

harlananelson — Fri, 28 Oct 2016 13:20:00 GMT

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