Accessing and Manipulating Data in SAS Viya

[r0oki3]

I am trying to create a calculated column in SAS Data Prep. Max(Date) by ID. 

ID  Date

1    09/06/89

2    01/19/93

3    09/08/93

1    09/04/85

1    09/04/91

2    09/09/92

I used the max(date) function but it returns the same date value.

[Reeza]

You have to ensure you do it for the BY group. This may be easier as a calculated measure (I'm assuming SAS VA) that allows you to do a Grouped calculation.

[r0oki3]

I am on SAS VIYA 3.3. I am using a web based client of VA.