Jerry Alex Posted September 25, 2019 Share Posted September 25, 2019 Hi: I've configured the Spotfire Statistical Services to the SAS engine and followed all the instructions to the T. I've tested the stats URL (with the SAS engine) in the browser and when I pass in the SAS coded within the URL it works as expected giving me an XML output of the results. Now the interesting or rather the frustrating challenging aspect of this is, when I try to create a data function using the exact script that worked via the URL from within the Spotfire Analytics session - it fails. Actually it fails if i were to use a SAS script that calls in a 'set' statement to take in the name of a data table passed in as a parameter ('TABLE') value from the data functions options. However, if i use a simple SAS script that does not use the 'SET' statement but rather a sequence of loop statements to create observations - it works fine. Attached is the error I'm receiving. There is no error returned from within the SAS code execution. But the error is thrown when Spotfire tries to retrive back the final dataset created by the SAS script. I've exhausted all options tying to find out the cause but to no avail. I could really use some help in helping me analyze the problem or what I should do to resolve this issue. I've attached a screenshot of the error I'm receiving. Link to comment Share on other sites More sharing options...
Khushboo Rabadia Posted September 27, 2019 Share Posted September 27, 2019 Hello, Can you check if "Enable Data function debugging" is checked or not, under Tools > Options > Data functions. If it is checked, can you uncheck that option. Restart Spotfire analyst application and then again try to run your SAS script. Link to comment Share on other sites More sharing options...
Jerry Alex Posted September 27, 2019 Author Share Posted September 27, 2019 WOW!!! Really!!! That simple huh!!! Thank you so much. That just did the trick. WOW!! Now there is no way I would've thought about that especially when I'm trying to debug the issue. Now I know. Thanks a lot Khushboo. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now