08-31-2016 11:10 AM
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.
08-31-2016 12:29 PM
09-06-2016 03:24 PM
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
09-06-2016 03:31 PM
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.
09-06-2016 04:17 PM
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?
09-07-2016 12:43 AM