topic DI Studio: New transformation not keeping code when added to job in Developers

DI Studio: New transformation not keeping code when added to job

theRabbitHole — Wed, 13 Jul 2022 14:30:24 GMT

I have some macro variables which need to be incorporated across multiple jobs.

Basically, a macro in DI Studio.

My initial solution: Creating a new transformation containing the code, e.g.

data _null_;
set DSET;
call symput('DATEVAR1 ', put(DATEVAR1 , 8.));
run;

However, when I add the transformation to a job, it does not retain the code.

The Code tab is empty.

Is there a different way of doing ? Would prefer a transformation, which will be available to other users as well.

DI Studio 4.904

OS: Win Server 2016

Re: DI Studio: New transformation not keeping code when added to job

a20121248 — Sat, 01 Oct 2022 07:15:01 GMT

Make sure you are creating the macro variable in that node. Also try using symputx instead of symput.

Check the value in that node:

%put &=DATEVAR1;

Not sure if it helps for you case, but there is a parameter tab with many, many options:

1.1. For a particular job:

1.2. In any transformation of that job:

Re: DI Studio: New transformation not keeping code when added to job

Patrick — Sat, 01 Oct 2022 23:00:28 GMT

I can't remember ever having had such an issue with a custom transformation. What I would do in such a case using DIS:

Close all jobs
Export your custom transformation (.spk)
Delete the custom transformation
Open a DIS job that used the custom transformation
1. To ensure you're not using a "duplicate". The custom transformation shouldn't be in the job anymore.
Import the .spk
1. In my experience such an export/delete/import approach can fix some metadata hiccups
Add the custom transformation back to the job
Check in the code tab of the job if you can see the custom transformation code as desired
1. If you can see it save the DIS job, close it, open it again, check again in the code. If still there then you should be fine.

If above still doesn't resolve your issue then I'd check if it's an issue with your DIS job or with the custom transformation by:

Create a new DIS job, add the custom transformation, check if that generates the desired code (after save/close/reopen the DIS job).
1. If it doesn't create the desired code then I'd delete the custom transformation and create a new one from scratch
2. If it does create the desired job then I'd export/delete/reimport the DIS job with the custom transformation as this might fix things (just the job without the dependent objects).

...and if all of the above doesn't help then I'd contact SAS Tech Support

Re: DI Studio: New transformation not keeping code when added to job

LinusH — Mon, 03 Oct 2022 06:38:44 GMT

Of course you can try out the trouble shooting suggestions in this thread.

But since this data doesn't seem to have any direct impact of you data flow (lineage), you could either create an actual macro, and call that in your jobs pre-code.

Or, if you bu multiple jobs mean almost all jobs, execute the code in the autoexec.