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

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

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
  • 943 views
  • 0 likes
  • 2 in conversation