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 |
proc sql;
create table want as
select
LocationType,
count(distinct Location) as uniqueLocations
from JANFEB.SAMPLEUNIQUE
group by LocationType;
quit;
proc sql;
create table want as
select
LocationType,
count(distinct Location) as uniqueLocations
from JANFEB.SAMPLEUNIQUE
group by LocationType;
quit;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.