topic Re: Can SAS VA access SAS programs like SSRS? in SAS Visual Analytics

Can SAS VA access SAS programs like Microsoft's SSRS accesses SQL programs/jobs?

Ramakanthkrovi — Mon, 17 Sep 2018 00:52:12 GMT

Hi guys,

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?

Regards,

Rama

Re: Can SAS VA access SAS programs like SSRS?

AndrewHowell — Fri, 14 Sep 2018 03:03:14 GMT

Elsewhere (Enterprise Guide) create a SAS stored process with prompts
When designing a Visual Analytics report, add a Stored Process object.
Other VA objects (report/section filters, etc) can create & populate parameters; these parameters can be passed to the VA Stored Process object, which can consume them as macros.

Re: Can SAS VA access SAS programs like SSRS?

SASKiwi — Fri, 14 Sep 2018 03:30:10 GMT

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.

Re: Can SAS VA access SAS programs like SSRS?

AndrewHowell — Sun, 16 Sep 2018 11:12:30 GMT

@SASKiwi - I think @Ramakanthkrovi is referring to the Microsoft SQL Server Reporting Services (SSRS - I don't think SAS "does" 4-letter acronyms..) being able to call pre-defined code.

Re: Can SAS VA access SAS programs like SSRS?

SASKiwi — Sun, 16 Sep 2018 20:09:06 GMT

@AndrewHowell - thanks for the clarification. "SAS programs like SSRS" had me confused.

Re: Can SAS VA access SAS programs like SSRS?

AndrewHowell — Mon, 17 Sep 2018 00:09:24 GMT

Read: "SAS programs similar to Microsoft's SSRS"

Re: Can SAS VA access SAS programs like SSRS?

Ramakanthkrovi — Thu, 20 Sep 2018 01:38:07 GMT

@AndrewHowell is it not possible for other users to execute the stored process if they don't have SAS EG access?

Re: Can SAS VA access SAS programs like SSRS?

AndrewHowell — Thu, 20 Sep 2018 03:52:38 GMT

@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.

Re: Can SAS VA access SAS programs like SSRS?

Ramakanthkrovi — Thu, 20 Sep 2018 03:59:01 GMT

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?

Re: Can SAS VA access SAS programs like SSRS?

AndrewHowell — Thu, 20 Sep 2018 04:08:50 GMT

When creating the stored process, did you register it to use a workspace server or the stored process server? (Should be stored process server, which uses a shared credential).

Re: Can SAS VA access SAS programs like SSRS?

Ramakanthkrovi — Thu, 08 Nov 2018 04:54:08 GMT

@AndrewHowell

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?

Regards,

Rama