BookmarkSubscribeRSS Feed
shamps
Calcite | Level 5

Morning all,

I work within Hospital episodes and we are exploring the use of SAS EG as a reporting/querying tool as opposed to Business Objects but the one thing that is not present when performing a join to another table (for lookup/reference purposes) is a CONTAINS operator.

CONTAINS is present in DI on a sql join and I am aware that you can amend the code within EG to state CONTAINS but this would be a really useful feature of EG that when you join two tables together you can state (for example)

 

t1.DIAG3 = t2.CODE

In this example - if the t1.DIAG3 was a single code and then the t2.CODE was not as specific - you could use CONTAINS, IS LIKE, MATCHES etc... within DI but not in EG - All EG offers you to select from is basic =, <=, >=, ^=, and then < or > - I dont want to amend the code as then every time a user needs to perform this, they have to have some knowledge of code to be able to use EG.

This is particularly useful when trying to search for a diagnosis code (t1.DIAG3) that appears within a long concatenated string of diagnoses...

Can anyone shed any ideas how to get around this issue...?

Many thanks

Steve

1 REPLY 1
LinusH
Tourmaline | Level 20

Is DIAG the only join column? If so, Ican't see a point and click way to do this in EG.

One "stupid" work-around could be to add column to each table always containing the value 1, and join on that. Then you could get the user to use "Filter to include in the join tables on-clause"..."Edit", where CONTAINS is available in the advanced filter builder.

Data never sleeps

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 933 views
  • 0 likes
  • 2 in conversation