Note: I am on v7.4.
Is it possible for VA to access and run a program by itself with dynamic values (user input) as macro variables. If a user enters the from and to dates, the macro variables in my code can automatically run the code for the dates entered ? or any such instances where user input can access the macro variables dynamically and change the value and execute the program?
@Ramakanthkrovi - I only suggested EG as the simplest way to create the stored process. The stored process can (should?) be able to be executed by any SAS (metadata) client: EG, Visual Analytics, Add-In for Microsoft Office, Stored Process web application, etc.
I have created the Stored Process in SAS EG and executed it from VA. It worked fine for me as it is created by me but when someone else tried to access the stored process from SAS VA Viewer, they were not able to execute the stored proc because SAS EG needs my(developer) credentials. Is there a workaround this issue?
I tried to run it under "Stored Process Server only" as suggested but I get this error when I try to execute :
ERROR: Failed to load analytic extension for the distributed computing environment.
There are two datasets which have to be loaded in memory in the same program. Do you think that could be the reason because out of the two the second one is loaded into memory without error but the first one is throwing the error. Anything that should be checked?
What is SSRS? SAS uses hundreds of acronyms so please be specific.
Please be aware that SAS VA is a "cut-down" version of SAS that may not necessarily have all of the functionality of traditional SAS. If SSRS uses any functionality not in Base SAS then it is highly likely to fail.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.