BookmarkSubscribeRSS Feed
sas_Forum
Calcite | Level 5

Hi

i am using the Data management studio 2.5 .How can i point the qkb and where should i select the qkb-ENIND,ENUSA

1. I have pointed the Dqsetup.txt --But no working

2.Pointed to QKB folder --But not working

4 REPLIES 4
Heath
SAS Employee

Thank you for your question.

Have you had a chance to review this topic in the DataFlux Data Management Studio online Help? We have step-by-step instructions on how to select a QKB from your Data Management Studio software. In the Table of Contents on your left, browse to Administration Riser Bar > Using Quality Knowledge Bases > Selecting and Reloading Quality Knowledge Bases.

Here are the steps listed in this documentation topic:

  1. Access the Administration riser and click Quality Knowledge Bases to display the Quality Knowledge Bases pane.
  2. Click New to access the Add Quality Knowledge Base Location dialog.
  3. Enter the name for the Quality Knowledge Base.
  4. Click Browse and navigate to the location where the Quality Knowledge Base has been installed.
  5. Select or deselect the Set as default and Private options as needed.
  6. Click OK to save the selection and close the dialog.
  7. Open the DataFlux Data Management Studio Tools menu and click Reload QKB. The Quality Knowledge Base is reloaded. If you do not reload the newly selected Quality Knowledge Base, you must close and reopen DataFlux Data Management Studio to use it.

I hope this helps you connecting to your SAS Quality Knowledge Base. Please let us know if you need additional assistance with this matter.

Thank you,

Michele

sas_Forum
Calcite | Level 5


HI

i have done the steps but not working

i have pointed the QKB to

1 .path pointed to      ------dqquality\sasmisc\QltyKB   --No twoked

2.path pointed to       ------dqquality\sasmisc\QltyKB \dqsetup.txt  -Not worked

can you gice me the path exactly where to point

MKQueen
SAS Super FREQ

You need to point to your QKB path to the path that contains folders with the names of:

  • chopinfo
  • grammar
  • locale
  • phonetx
  • regexlib
  • scheme
  • vocab.

In the case of the QKB for CI 25 by default that path is: C:\ProgramData\SAS\SASQualityKnowledgeBase\CI\25.  See screenshot below.

QKB_path.png

Note:  In most Windows installation the C:\ProgramData folder is a hidden folder and you may need to unhide it in order to navigate to it.

Rain
Obsidian | Level 7

We had similar issue when setting environmental variables for Event Stream Processing in Linux to use QKB. Although examples say "data folder" it meant actually "/opt/sas/viya/home/qkb/data/ci/29" for us. After changing DFESP_QKB  Event Stream Processing was able to run data quality tasks in ESP project also.

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

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
  • 4 replies
  • 2680 views
  • 0 likes
  • 4 in conversation