cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
BookmarkSubscribeRSS Feed
jonasc
Calcite | Level 5 jonasc
Calcite | Level 5

Missing Business Key Column Option SYMBOLGEN: Macro variable SYSERR resolves to 0 SAS DI

Posted 11-28-2017 03:35 AM (1343 views)

I try to use a surrogate key generator in SAS DI but I keep getting the following error. What am I doing wrong?

 

Surrogate Key Generator

Line 2,530: ERROR: Missing Business Key Column Option SYMBOLGEN: Macro variable SYSERR resolves to 0

0 Likes
Reply
1 REPLY 1
LinusH
Tourmaline | Level 20 LinusH
Tourmaline | Level 20

Re: Missing Business Key Column Option SYMBOLGEN: Macro variable SYSERR resolves to 0 SAS DI

Posted 11-28-2017 05:48 AM (1312 views)  |   In reply to jonasc

You either not provided enough information in the transformation, or it doesn't match the physical data.

Too little information provided to help you more.

Data never sleeps
0 Likes
Reply
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.

Watch How to connect to databases in SAS Viya on YouTube

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • ‎11-28-2017 03:35 AM
  • 1344 views
  • 0 likes
  • 2 in conversation