Hi All,
I'm trying to get the jobname from a SAS DI Studio job as a variable in my DI transformation, so I can write this information to a seperate table. I've created two new columns in an Extract with the JobID and JobName. For the JobID I use the macro &SYSJOBID which resolves nicely. For the JobName I am using &etls_jobName. Unfortunatly this is not working. The error I get is:
"Unable to execute query: SQL passthru expression contained these errors: ERROR: The following columns were not found in the contributing tables: <The actual Jobname>.
Does anyone know what I am doing wrong, It seems that the macro is resolving but I am not getting the jobname as a variable in my extract.
Can you provide us with the code of the transformation and the actual log? That would greatly help in what seems a simple issue.
Regards,
- Jan.
You my friend, you are a hero. Thanks!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.
Find more tutorials on the SAS Users YouTube channel.