Hello,
Simple problem: I need to create a data set in which the maximum value is reported for each categorical variable. For example:
Col1 Col2
a 2
a 1
a 0
b 3
b 0
c 1
c 2
c 3
Would read as follows:
Many thanks!
data have;
input Col1 $ Col2;
cards;
;
proc sql;
create table want as
select col1,max(col2) as col2
from have
group by col1;
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.
Register now!
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.
Select SAS Training centers are offering in-person courses. View upcoming courses for:
View all other training opportunities.