BookmarkSubscribeRSS Feed
JohnJPS
Quartz | Level 8

Just a general high-level question, fishing for recommended approaches / best practices.

 

We want to deploy models that take a subset of input, enhance that input by performing a couple lookups, and then run the model using that larger set of inputs.  What we're finding is that the "lookup tables" option in Decision Manager isn't really what we're looking for here: we'd like the additional lookups to be defined in DI Studio such that a nightly batch process could easily update the lookup table(s).

 

The process in question is real-time, so the lookups are not too complex.  But we simply don't see how to add custom data retrieval to anything that gets deployed via Decision Manager/Builder.

 

Any ideas on how to go about that?

 

Thanks!

2 REPLIES 2
ballardw
Super User

You may want to provide a brief example of some start data, a few rows of dummy values, some corresponding lookup data and what the result should be after the look up. That may help those that understand DI provide more targetted responses.

 

I can't suggest as I don't use DI but the wording you are using almost makes me think your definition of "look up" may have some top-spin that I wouldn't use that same term for.

JohnJPS
Quartz | Level 8

Thanks for the quick response.  A simple example would be, say, deploying a predictive model that uses zip code as an input, but along with that it requires various demographic information that we can retrieve using the zip code. So for example, we want to look up the demographic inputs given the zip code input... all as part of the scoring process.

 

One easy solution is to tell the calling system to do the lookup in advance, and thus provide both zip and demographic information up front, but unfortunately we are not in a position to make those demands at this time.

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!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

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