Hi, I try to configure mail service in sas viya 4 , to be able to send mails from platform, without the code. If I want to send an email by code from a sas program the mail is sent, I used this part of code: options emailhost= ( "smtp.host.com" STARTTLS auth=LOGIN id=" mail@xxxx.xxx" pw="xxxxx" port=587 ); filename mymail email "mail@xxxx.xxx" subject="My SAS Configuration File"; data _null_; file mymail; put 'Jim,'; put 'This is my SAS configuration file.'; put 'I think you might like the'; put 'new options I added.'; run; I tried to add the same options in sas.mail, but I think the problem is that I don't know where to add the STARTTLS or auth=LOGIN . Can you help me with this problem. Thank you, George
... View more
I have a very large dataset and I am trying to replace several numeric and character variable values (trying to null all of the values with certain variables) with either a blank or null (.). I tried the following code but got several error messages. Is this the best code or are there others? proc iml; edit mp_; read all var (Result1) where (Result1 ^= '0'); Result1 = ' '; replace all var (Result1) where (Result1 ^= '0'); run; 4 proc iml; NOTE: Writing HTML Body file: sashtml.htm NOTE: IML Ready 5 edit mp_; 6 read all var (Result1) where (Result1 ^= 0); ERROR: Operand Result1 does not have a value. statement : READ at line 6 column 1 7 Result1 = ' '; 8 replace all var (Result1) where (Result1 ^= 0); ERROR: An exception has been encountered.
... View more
SAS Viya Workbench is coming! Built for developers and modelers, Viya Workbench is a self-service, on-demand compute environment for analytical development, including building AI and machine learning models. We're excited about the release next month and are dedicating the June edition of the SAS Bowl to it.
Game Details
The SAS Support Community trivia event, SAS Bowl XLI, SAS Viya Workbench is scheduled for Wednesday, June 12, at 10 a.m. ET.
Register for the event and receive an invite to a Microsoft Teams meeting and a calendar event.
On game day, join the Teams meeting and access the game here.
More on SAS Viya Workbench
Build powerful models quickly and efficiently through the code-based environment. An intuitive user interface and integrations with your favorite IDEs get up up and running in minutes. Streamline your work by pulling in existing Python or SAS projects - with minimal to no code modifications needed. Boost your productivity and performance by customizing your CPU/GPU compute power to fit the needs of your project. Develop on-demand with self-provisioning and self-terminating features requiring minimal IT support. Workbench allows you to focus on creating, innovating, iterating, and testing your work through a code-based interface using Juypter Notebooks and Visual Studio Code.
Here are some resources where you can learn more and get familiar with SAS Viya Workbench.
SAS Viya Workbench home page
Press Release announcing SAS Viya Workbench
Ask the Expert Webinar on SAS Viya Workbench
SAS Viya Workbench: The Final Countdown to Launch
SAS Bowl and event details
For those who may be new to the SAS Bowl, you can find game history and specifics in this Community memo. There you'll also find links to previous events, which include recordings.
Register for the event and receive an invite with game details and a Teams meeting link. On game day, Join the TEAMS meeting to play, and show off your SAS and worldly knowledge while competing for bragging rights and SAS Community game gear.
... View more
SAS 9.4
When current SAS code completes, the last window open, on top, is the "Results" window. User wants SAS to return to the "Log" window, programmatically. The answer, via searching, seems to be: /* Command to switch to the Log window and maximize it */ dm 'log; wmaximize;';
Unfortunately, that doesn't seem to work. Seems to be entirely ignored. Top window continues to be "Results". Even though the above command does appear in the log window (when user manually returns there, by way of mouse click on log 'tab').
Suggestions greatly appreciated.
... View more
I have a dataset Id system1 system2 system3 system4 1 0001 0001 0001 0002 2 0002 0001 0002 0003 3 0003 0002 0002 0004 4 missing 0001 missing missing I want to the new data set to include a new column which is the most frequent value across these systems. Id system1 system2 system3 system4 mostfrequent countofmostfrequent 1 0001 0001 0001 0002 0001 3 2 0002 0001 0002 0003 0002 2 3 0003 0002 0002 0004 0002 2 4 missing 0001 missing missing 0001 1 Any help you can provide would be greatly appreciated!
... View more