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.
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.
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.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.