Dear community,
I need to use parameters in DI Studio. I have defined the parameters in the "Parameters" tab of the transformation (User Written Code), successfully tested them (each of them uses a specific dynamic list) in the transformation properties but when I run the transformation I do not get any prompt for the parameters.
Does anyone have an idea / hypothesis as to what is missing here?
Many thanks in advance
Cheers
Anne.
DI Studio is a development tool.
Parameters is meant to be popoluted/assigned values during execution time - main scope is batch mode.
Then of course from a unit testing perspective it would be nice to be able to interctively assign values from the DI Stuido UI. But unfortenately that is not how this works. So you need a way to assign the parameters temporarely, in a pre-step, or if you export the code to a separate code window/Enterprise Guide and assign the parameter value there manually.
DI Studio is a development tool.
Parameters is meant to be popoluted/assigned values during execution time - main scope is batch mode.
Then of course from a unit testing perspective it would be nice to be able to interctively assign values from the DI Stuido UI. But unfortenately that is not how this works. So you need a way to assign the parameters temporarely, in a pre-step, or if you export the code to a separate code window/Enterprise Guide and assign the parameter value there manually.
Many thanks for your very prompt and clear answer @Linus_H.
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.