BookmarkSubscribeRSS Feed
neetavarma
Calcite | Level 5

I am getting this error while running a template. We have checked the Infomap and its data items for the customised properties, all are good. We have created the new business context and it is connected to the Infomap. If the template has single data item then the count is reflecting but then more than two data items (conditrions) The SAS code is generating the code which is pointing to some null. table 

 

PROC SQL;
Create table WORK.MA6 as
 SELECT
 ( count(*) ) AS DII_1 LABEL=''
 FROM
 (
 SELECT DISTINCT
 table0.'cifno'n AS CIFNO LABEL='cifno' FORMAT=$400.
 FROM
 CMDMLIB.'cinfomap_final'n table0

Inner join CMDMLIB.'cc_infomap'n table1

on table0.'cifno'n = null.'cifno'n
 WHERE
 table1.'cc_active_customer'n = '1' AND
 table0.'cc_ever_hold'n = 1
 ) table2 ;

 

ERROR: Unresolved reference to table/correlation name null., Dump stack trace & continue.

 

Please suggest how to resolve this?

1 REPLY 1
MarkKorey_sas
SAS Employee

Hi @neetavarma -

This looks like a pretty technical issue specific to your environment.

To get you some dedicated support, please contact Tech Support and include as much detail as possible. On the CI360 Home Page --> Resource Center you'll find a link to "Contact technical support". This will launch a email w/ a template for you.

G2 Grid Leader Spring 2025.png

 

 

 

 

Want to review SAS Customer Intelligence 360? Gartner and G2 are offering a gift card or charitable donation for each accepted review. Use this link for G2 to opt out of receiving anything of value for your review.

 

Gartner.jpg

 

SAS Customer Intelligence 360

Get started with CI 360

Review CI 360 Release Notes

Open a Technical Support case

Suggest software enhancements

Assess your marketing efforts with a free tool

 

Training Resources

SAS Customer Intelligence Learning Subscription (login required)

Access free tutorials

Refer to documentation

Latest hot fixes

Compatibility notice re: SAS 9.4M8 (TS1M8) or later

How to improve email deliverability

SAS' Peter Ansbacher shows you how to use the dashboard in SAS Customer Intelligence 360 for better results.

Find more tutorials on the SAS Users YouTube channel.

G2 Grid Leader Spring 2025.png

 

 

 

 

Want to review SAS Customer Intelligence 360? Gartner and G2 are offering a gift card or charitable donation for each accepted review. Use this link for G2 to opt out of receiving anything of value for your review.

 

Gartner.jpg

 

SAS Customer Intelligence 360

Get started with CI 360

Review CI 360 Release Notes

Open a Technical Support case

Suggest software enhancements

Assess your marketing efforts with a free tool

 

Training Resources

SAS Customer Intelligence Learning Subscription (login required)

Access free tutorials

Refer to documentation

Latest hot fixes

Compatibility notice re: SAS 9.4M8 (TS1M8) or later

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