BookmarkSubscribeRSS Feed
paulrockliffe
Obsidian | Level 7

I've got a project that clashes a couple of data tables together.  There's a problem with duplicates within one of the tables, but I'm able to correct some of the duplicates by bringing in some other data and doing some messing around to find the pairs of duplicates where I know enough about one or the other to work out which one is the error.

 

I've created a table of errors to filter out and joined this back to my process flow to correct the data.  I want to be able to turn the feature on or off via a Prompt as there are some circumstances where it's better to have the duplicates.

 

When I thought about this in the car I figured it would be easy to do as I just need to work out the filter to remove duplicates and then add a second filter "&Prompt = Yes" to the filter, so if the Prompt is set to No there will be no cases that match all the criteria.

 

Of course on trying to build this I've remembered that Prompts don't work this way, so now I'm stuck!  I know I can use conditional processing but this filter is at the start of a very long and complicated flow and I don't want to have to duplicate everything from this point.  With it being a simple filter that should be unnecessary.

 

But how do I do it?  This is EG5.1.

 

Thanks!

1 REPLY 1
tomrvincent
Rhodochrosite | Level 12
Have you upgraded to EG7 since this post?

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
  • 848 views
  • 0 likes
  • 2 in conversation