How to create unique ID table with specific conditions?

[FredGuo]

Hi,

I am beginner of SAS visual analytics.

I had a duplicated ID table including some variables, and I want to create the table one row each ID and the outcome=Y if the ID had anyone outcome=Y, or outcome=N by manipulating it in Viya 3.5.

Because this data doesn't any number variables, I can't reach the above target by aggregating them and join back the table with filtering date=Max(date)

Before：

Want：

Thank you.

[ballardw · Accepted solution]

I know it is too late for this but Y/N, Yes/No, True/False, T/F values really work best as 1/0 coded numeric values and things like this is just one example.

Just because someone gives you poor data does not mean you have to use it in a poor form.

[FredGuo]

Dear ballardw, Thank you!