topic Re: How to create unique ID table with specific conditions? in SAS Visual Analytics

How to create unique ID table with specific conditions?

FM_MF — Thu, 20 Jul 2023 14:39:27 GMT

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.

Re: How to create unique ID table with specific conditions?

ballardw — Thu, 20 Jul 2023 14:46:12 GMT

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.

Re: How to create unique ID table with specific conditions?

FM_MF — Sat, 22 Jul 2023 03:20:49 GMT

Dear ballardw, Thank you!