BookmarkSubscribeRSS Feed
deleted_user
Not applicable
In my job I m using a surrogate key generator transform for which the target table is an oracle table. Whenever I close the job and reopen it and run it, the job is not able to find the target oracle table…
Here is the snap from the log

SYMBOLGEN: Macro variable TARGETTABLE resolves to ORADIM.DIM_CASE_STATUS
SYMBOLGEN: Some characters in the above value which were subject to macro quoting have been unquoted for printing.
MLOGIC(CREATESURROGATEKEY): %IF condition (%sysfunc(exist(&targetTable)) eq 1) is FALSE

However, when I run job for the second time(ie without closing it) then it is working fine…
Can u pls help me with this?
1 REPLY 1
LinusH
Tourmaline | Level 20
I think SAS support will the proper way to solve this issue.

/Linus
Data never sleeps
Creating Custom Steps in SAS Studio

Check out this tutorial series to learn how to build your own steps in SAS Studio.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

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