Hi @SalihKilic ,
I am not sure how to help you. You are aware that SAS Viya 3.5 is not as evolved as SAS Viya 4 (and never will be), and you investigated and confirmed that the functionality you are looking for is not present. Still you receive some hel that could resolve the issue, yet you have a hard time accepting it as it adds complexity - and I understand it, however it does not make easy to provide you help.
My 2 cents to this matter, some options:
1- think about moving to SAS Viya 4
2- perhaps you could use a framework which, might initially look like adding complexity, in fact it would reduce it. Examples: SAS App Factory (not sure if it is compatible with Viya 3.5 though), h54s from Boemska or SASjs/Data Controller from 4GL Apps. You will notice a lot of similarities and a basic common concept among those.
3- Take a common developer approach: If you are able to create a webservice which internally would run a SAS job execution, and transfer data via json, you should be able to update the field dynamically. However, doing it on your own might not be the most fast or efficient way, or secure, so it could be frustrating to you. That is why some smart people created the frameworks indicated in #2, or why SAS continued the development of the SAS Job Execution capabilities in SAS Viya 4.
Perhaps you already considered those options. Then hearing why they are discarded could be interesting to understand your selection process and priorities.
... View more