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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.