Hello, I am trying to send e-mails with SAS using the cloud-based service SendGrid to no avail.   I can successfully send e-mails without SAS by following these steps from SendGrid documentation : https://docs.sendgrid.com/for-developers/sending-email/getting-started-smtp   For SAS, I tried using these two different options, but they both give me errors. options emailhost= ( "smtp.sendgrid.net" port=25 auth=plain id="apikey" pw="my_plain_api_key" ) ; options emailhost= ( "smtp.sendgrid.net" port=25 auth=login id="YXBpa2V5" pw="my_base64_api_key" ) ; Any idea on what I am doing wrong? Any help would be appreciated. Thank you in advance 🙂 ... View more

Ok @yabwon you were spot on, I removed the escape from the code to make it a space, I thought these were special characters causing issues and it imported just fine.      Thank you everyone for your help ... View more

Whoever wrote that %Replace_CRLF macro (via the link to GitHub) has produced a very simple, yet elegant solution to the problem of LF characters embedded in free-text fields. It looks like it is easily extensible as well. Nice work, thanks. DownunderDave Wellington ... View more

@laagri  Currently the best option to hide the path is to change the title of the job using the _title url parameter and set it to blank.  This can be done using a url like this one:  https://server.demo.sas.com/SASJobExecution/?_program=%2FUsers%2FmyUser%2FMy%20Folder%2FNoTitleJob&_title=%20 It means you should just add &_title=%20 at the end of the job url. Let me know if you have question.  Regards,  Xavier ... View more

Your Visual Analytics visualizations? We have no plans to rebuild those in Databricks, we'll be using PowerBI for those instead. ... View more

So change this line: infile dummy filevar=location end=done encoding='any' truncover; And add these two lines later: do while (not done); input @; _infile_=translate(_infile_,'7C'x,'A6'x); input RECORD_TYPE_CODE $1. @; ... View more

Thanks @Ksharp another great solution ... View more

Awesome Thanks @Tom that works. Appreciate your help ... View more

Yes, that's one way of doing it! We have a bunch of demo SAS web apps you can check out here: https://github.com/search?q=topic%3Asasjs-app+org%3Asasjs+fork%3Atrue&type=repositories There is also a support group: https://matrix.to/#/#sasjs:4gl.io ... View more

Hi @pritesh_sas ,  Thank you for the positive comment.  There is no interaction out-of-the-box between VA report object and SAS Job Execution object. The only option is to use a Data-Driven Content object and to build a custom web page to handle the parameters collection and the job execution. The logic will be to pass data from the VA report to the DDC object for example when you select a row in a list table. Then the web page used for the DDC object will manipulate the data and send the request to the Job Execution which will execute and return the result. You have different options to launch the job, you trigger the job execution as soon as the data selection changes without user interaction in the DDC object. Or you populate a form in the DDC object and the user needs to trigger the execution by clicking on a submit button for example.  I hope this helps you.  If you have questions, please don't hesitate to contact me.  Regards,  Xavier  ... View more

Hi,    Report Summary functionality is available since version 8.5 of Visual Analytics.  To define the Report Summary, you should select the report object and not a specific object. You can see this in the video in this blog. If you don't select the report top level, you will not be able to add the summary.  If this is not working, you should most probably check with Technical Support. They will be able to help you solving that issue.    Regards,  Xavier ... View more

@Renato_sas  Yeah got it to work! looked up some of the errors in the console log, turns out one of the extensions was causing an issue removed it and now I see the results!     ... View more

Thanks @XavierBizoux , so data is available to report on, and the part of capturing the data in the tables is working, so at least i know that works which is what I really care about. I'm sure I'll have more question now that I am trying to build my own. Thanks for getting back to me. ... View more

Thanks Chris, I've tried the termstr=LF as well as cr, crlf and every combo of scanover, truncover etc and it still doesn't read the data in properly, the issue I have is an unexpected LF in the middle of quoted data, so the full line is not read in for the record and instead the rest of the data is read in as another record. Is there another way to deal with issues like this, I would love to not have to rewrite the files. thanks   ... View more