topic How to create a new column based on the highest value from multiple columns in New SAS User

How to create a new column based on the highest value from multiple columns

Re: How to create a new column based on the highest value from multiple columns

Re: How to create a new column based on the highest value from multiple columns

Re: How to create a new column based on the highest value from multiple columns

Re: How to create a new column based on the highest value from multiple columns

Sam1010 — Fri, 01 Sep 2023 05:13:26 GMT

Hi guys, I have a dataset that looks like this:

Patient ID	Age1	Age 2	Age3	Age4	Age5
1	65	60	45	50	24
2	30	66	82	71	58
3	29	45	18	10	31

How do I create a 6th column (Age_final) where Age_final is the highest value identified from the 5 columns. Please note that my dataset has hundreds of rows.

An ideal dataset will look like this:

AKHILA — Fri, 01 Sep 2023 06:59:54 GMT

Please try:

Age_final=max(age1,age2,age3,age4,age5)

Patrick — Fri, 01 Sep 2023 07:03:22 GMT

Use either function max() or largest()

data sample;
  infile datalines truncover;
  input id age1-age5;
  max_age_1=largest(1,of age:);
  max_age_2=max(of age:);
  datalines;
1 5 4 6 9 2
;

Sam1010 — Fri, 01 Sep 2023 07:15:07 GMT

Great. This works. Thank you.

Patient ID

Sam1010 — Fri, 01 Sep 2023 07:16:08 GMT

Also works. Thanks.