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
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
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.
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?
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.