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.
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.