cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
pw182126
‎11-11-2021
  • 8 Posts
  • 0 Likes Given
  • 1 Solutions
  • 0 Likes Received

Re: Authentication OAuth - 2nd PROC HTTP fails

by Fluorite | Level 6 in Developers
‎11-08-2021 05:26 PM
‎11-08-2021 05:26 PM
Hi! We have the same issue. Unfortunately we need to use POST request in order to transfer big JSON as input parameter for the job. The URL limit is about 2000 character. We need to send mote than this and that why we need to use POST request.   In the jobexecug 2.0 documentation I can see that it must be possible:   "jobexec.method HTTP method used when this request was made (for example, GET, POST, or PUT)."   Hope there is a solution for this 🙂 ... View more

Re: SAS Viya VA - DDC - web content - JavaScript - server side logging

by Fluorite | Level 6 in New SAS User
‎01-13-2020 02:43 PM
‎01-13-2020 02:43 PM
Thank you! I saw this documentation. But it is about how to enable or use the existing sas logging.   We are running a self made JavaScript web application inside a VA Report. What I try to understand what JavaScript framework is used in SAS Viya for the server side logging? Is there an API/interface which I could use to save my own logs to the server. I guess there is no way to use the native SAS logging for our purposes, so we might end up using some of these solutions: http://js.jsnlog.com/ http://log4javascript.org/docs/quickstart.html ... View more

SAS Viya VA - DDC - web content - JavaScript - server side logging

by Fluorite | Level 6 in New SAS User
‎01-10-2020 11:01 AM
‎01-10-2020 11:01 AM
Hi! Just wondering how the server side logging is implemented in VA? Is there a way to connect or reuse it from a DDC or a web content? Currently for debug purposes we are using just a basic console.log(), but it is not ideal for a proper web development and maintenance. Instead of developing "new wheel" or use third party libraries, I though maybe there is a way to use the Viya logging framework. Any ideas, suggestions?   Cheers Paul ... View more

Re: Viya dynamic Report Links (DDC)

by Fluorite | Level 6 in SAS Visual Analytics
‎04-12-2019 08:01 AM
‎04-12-2019 08:01 AM
Just got a response from SAS support team: "because of security reasons. When we write out the iframe for the DDC (or web content) it has to follow a specific set of sandbox options and these options/rules have been laid out after careful consideration by our security experts." So, it is not possible. ... View more

Viya dynamic Report Links (DDC)

by Fluorite | Level 6 in SAS Visual Analytics
‎04-09-2019 11:13 AM
‎04-09-2019 11:13 AM
Hi, just wondering if there is a possibility in Viya VA to build dynamic Report-Links which will open the VA-Report in the same browser tab or an Info-Window. Certainly we can build a table with the hidden ReportURI and use the dynamic Web-Link as described here: But this will open the Report in the new Browser-Window. Another option would be to use data driven content or web content, but there I cannot even execute any links. none of these is working:   <button onclick="openSelf()">_self</button> <button onclick="openBlank()">_blank</button> <script> function openSelf() { window.open("/SASReportViewer/?reportUri=%2Freports%2Freports%2F1473ee71-740d-48fc-b903-b43c7d33a128", "_self"); } function openBlank() { window.open("/SASReportViewer/?reportUri=%2Freports%2Freports%2F1473ee71-740d-48fc-b903-b43c7d33a128", "_blank"); } </script>   Any Help would be much appreciated.   Cheers Paul ... View more

Re: Proc Export silently fails

by Fluorite | Level 6 in SAS Programming
‎09-04-2018 01:32 PM
‎09-04-2018 01:32 PM
Sorry, what do you mean with "XLSX engine does not support named ranges"? I can read and write any data and from/to different sheets.   proc import datafile=&excelFile      out=xlsdata dbms=xlsx replace;      sheet=Basedata; run;   proc export data=&data      dbms=xlsx      outfile=&excelFile      replace;      sheet=Basedata; run;     ... View more

Re: Proc Export silently fails

by Fluorite | Level 6 in SAS Programming
‎08-10-2018 04:56 PM
‎08-10-2018 04:56 PM
Couple of month ago our customer migrated to SAS 9.4, so I changed the proc export from dbms=excel to dbms=xlsx. The problem solved!   I'm afraid analysing the logs won't help. There is not even a little hint what could cause the issue. The problem occur very random   The only solution, what worked for us, was to analyse the timestamp and abort the process, then delete some data in excel file, save and rerun the process again.   Good luck! 😉  ... View more

Re: Proc Export silently fails

by Fluorite | Level 6 in SAS Programming
‎09-11-2017 08:58 AM
‎09-11-2017 08:58 AM
I have the same issue! Our report update script is scheduled on a monthly basis. Couple of month in a row the update with "proc export" work just fine, but than it fails "silently". I already have written a macro which compares the time stamp of the file and the current time. If the difference is more than 5 sec (for example) after an update I do abort with an error message. But it still doesn't solve the problem! I tried everything, like writing a blank data set into the spreadsheet. I also tried to delete the data set with proc datasets delete. In both cases the file doesn't get updated or chaged and process fails silently.   Only option is to change the file manually. Unfortunately it's not a solution as we want to eliminate manual intervention with the process.   Help?! ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎11-11-2021 09:49 AM
Quick links