Counting unique entries of one variable by a categorical variable

byeh2017 — Thu, 20 Apr 2017 19:17:55 GMT

Hello,

I have a sample dataset with the folliwing variables: ID, Location, and Locationtype. Location type is only 3 categorical entries of 1,2,3. How do I write a code that will count unique values of location for each of the 3 cateogries of locationtype?

Here is the sample code. Thank you so much.

data JANFEB.SAMPLEUNIQUE;
  infile datalines dsd truncover;
  input ID:BEST. Location:$1. LocationType:BEST.;
datalines4;
1,A,1
2,B,2
3,C,3
4,D,1
5,E,2
6,F,3
7,G,1
8,H,2
9,I,3
10,J,1
;;;;

I would like the output to look something like this

LocationType	Unique Locations
1	23
2	14
3	15

Re: Counting unique entries of one variable by a categorical variable

PGStats — Thu, 20 Apr 2017 19:35:37 GMT

proc sql;
create table want as
select 
	LocationType,
	count(distinct Location) as uniqueLocations
from JANFEB.SAMPLEUNIQUE
group by LocationType;
quit;

topic Counting unique entries of one variable by a categorical variable in SAS Programming

Counting unique entries of one variable by a categorical variable

Re: Counting unique entries of one variable by a categorical variable