topic Re: How do I link a user transformation to a sas Dataset in SAS Data Management

How do I link a user transformation to a sas Dataset

saspert — Wed, 31 Aug 2016 15:10:23 GMT

Hello,

I am trying to link a user transformation to a SAS Dataset. I have an intermediary 'update' transformation to do the actual task. I ran the di studio job but not able to see the expected output. I tried on propagating the columns and

I am relatively new to sas di studio 4.9

Line 533: ERROR: File WORK.W2ENFD6I.DATA does not exist.
Line 534: WARNING: The data set TMP1 may be incomplete. When this step was stopped there were 0 observations and 0 variables.
Line 534: WARNING: Data set TMP1 was not replaced because this step was stopped.

Thanks,
saspert

Re: How do I link a user transformation to a sas Dataset

LinusH — Wed, 31 Aug 2016 16:29:32 GMT

What are you trying to do?
What does the user written transformation do?
You probably need some input data to feed your job.

Re: How do I link a user transformation to a sas Dataset

saspert — Tue, 06 Sep 2016 19:24:58 GMT

I am trying to map an existing ETL process's fields to new ones. As part of upgrade, we moved from SAS Activity Based Management 7.1/ SAS 9.2 to SAS Cost & Profitability Management 8.1/ SAS 9.4.

In order not to break the ETLs, I am trying to map the new fields to the old fields.

By using the user transformation, I am able to create the new source table in SAS 9.4. But I am not able to map it back to the old layout

Re: How do I link a user transformation to a sas Dataset

LinusH — Tue, 06 Sep 2016 19:31:55 GMT

Sounds like you are doing quite a change.

In these kind of projects you need a DI Studio expert on site to direct and mentor.

Re: How do I link a user transformation to a sas Dataset

saspert — Tue, 06 Sep 2016 20:17:15 GMT

The changes may not be that complex if I can the very first job to work.

I am trying to understand SAS DI studio to atleast answer the questions from the business. I have a few questions actually -

1. The code inside the code panel does not seem to reflect the code inside the individual transformation. How do I ensure that it is in sync?

2. How do I keep a stored process, a di studio job and the original sas program in sync?

Re: How do I link a user transformation to a sas Dataset

LinusH — Wed, 07 Sep 2016 04:43:22 GMT

First, those are new questions, and should be asked in a seperate thread.

1. Ard you referring to the code tabs? They should be.

2. Creating Stored processes from DI Studio jobs is usually an exception. But that would be a part of your development and deployment process.
In normal development there are no original SAS programs, all programs are generated from jobs.