topic Re: Accessing and Manipulating Data in SAS Viya in Developers

Accessing and Manipulating Data in SAS Viya

r0oki3 — Mon, 25 Jun 2018 14:56:11 GMT

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.

Re: Accessing and Manipulating Data in SAS Viya

Reeza — Mon, 25 Jun 2018 15:13:32 GMT

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.

Re: Accessing and Manipulating Data in SAS Viya

r0oki3 — Mon, 25 Jun 2018 15:18:38 GMT

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