BookmarkSubscribeRSS Feed
cthnpe
SAS Employee

            We have some issues with Reference data when we update reference data, it still shows the old reference value on the visual investigator.

First, we assign the Code ‘0099’ to have the Reference Value as ‘TEST NEW PARTY’ as shown in the picture below.

cthnpe_0-1718008150811.png

 

 

Then, we updated the Reference Value of Code ‘0099’ to ‘TEST NEW PARTY_UPDATE’ as shown in the picture below.

cthnpe_1-1718008150832.png

 

Data from FSC_PARTY_DIM, party_number = HK_100020495, and column PARTY_IDENTIFICATION_TYPE_DESC = 0099. (as shown in the picture below)

cthnpe_2-1718008150838.png

The reference value that we updated should be ‘TEST NEW PARTY_UPDATE’, but it still shows the old reference value as ‘TEST NEW PARTY’ instead as shown in the picture below.

cthnpe_3-1718008150853.png

 

 

sas-innovate-white.png

Special offer for SAS Communities members

Save $250 on SAS Innovate and get a free advance copy of the new SAS For Dummies book! Use the code "SASforDummies" to register. Don't miss out, May 6-9, in Orlando, Florida.

 

View the full agenda.

Register now!

Discussion stats
  • 0 replies
  • 799 views
  • 0 likes
  • 1 in conversation