About snelll

snelll · ‎05-08-2018

Thanks everyone for you help. I was amazed at how quickly I got a response and will definitely reach out again when I need help. It turns out we were using the filter correctly but the data in two columns we were comparing were so slightly different (SSC|SPC vs SSC-SPC) that we didn't notice this was why we were not getting the results we expected. Your feedback made us look more closely as to why your advice confirmed our first approach but we were not getting the results. We used the filter in SAS EG as recommended by Reeza

snelll · ‎05-02-2018

thanks for you very quick reply Reeza. We're going to give it a try and I'll let you know if it does the trick for us.

snelll · ‎05-02-2018

I am fairly new to SAS and I am not a programmer. I have a report in which column A and Column B identify multiple organizations in which certain users have different responsibilities. In most cases, the organization name should be the same in both columns, however, we have discovered that this is not always the case. I would like to know if there is a way preferably in SAS VA or if not, in SAS EG that I run a query or report that will identify each row in which the value of Column A is not the same as the value in Column B. Hoping you can help. Currently using SAS EG 7.1

Online Status	Offline
Date Last Visited	‎10-31-2020 12:44 PM

Re: How do I compare multiple values in one column to multiple values ...

Re: How do I compare multiple values in one column to multiple values ...

How do I compare multiple values in one column to multiple values in a...

Re: How do I compare multiple values in one column to multiple values ...

Re: How do I compare multiple values in one column to multiple values ...

How do I compare multiple values in one column to multiple values in a...

SAS Analytics Explorers