BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
FredGuo
Calcite | Level 5

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:

FredGuo_1-1689862938116.png

 

Want:

FredGuo_3-1689863281628.png

 

Thank you.

1 ACCEPTED SOLUTION

Accepted Solutions
ballardw
Super User

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.

View solution in original post

2 REPLIES 2
ballardw
Super User

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
Calcite | Level 5
Dear ballardw, Thank you!

SAS INNOVATE 2024

Innovate_SAS_Blue.png

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. 

Register now!

Tips for filtering data sources in SAS Visual Analytics

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.

Discussion stats
  • 2 replies
  • 310 views
  • 0 likes
  • 2 in conversation