DATA Step, Macro, Functions and more

Counting unique entries of one variable by a categorical variable

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 77
Accepted Solution

Counting unique entries of one variable by a categorical variable

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


Accepted Solutions
Solution
‎04-24-2017 03:12 AM
Respected Advisor
Posts: 4,649

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

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

View solution in original post


All Replies
Solution
‎04-24-2017 03:12 AM
Respected Advisor
Posts: 4,649

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

proc sql;
create table want as
select 
	LocationType,
	count(distinct Location) as uniqueLocations
from JANFEB.SAMPLEUNIQUE
group by LocationType;
quit;
PG
☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 96 views
  • 0 likes
  • 2 in conversation