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;
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.