We are worried about the impact of these aggregations on the SAS compute server. If we will use SQL passthru, all the processing will be done on the Oracle DB? ... View more

Thank you for your feedback. I wasn't aware of this connection method until I saw it in Patrick's response. I was just testing if we could write to the Oracle database directly instead of the SAS compute server. I would like to ask you, does using aggregation between multiple Oracle databases in SAS Guide impact the performance of the compute server, or will all the processing be done in the Oracle server? We want to add connections to different Oracle databases to work with them in SAS Guide, but we don't want it to affect the performance of the computer server that is being used for another project. ... View more

Thank you so much for your help, After adding the libname statement to my code as shown below:   libname mytest odbc datasrc=&ds; proc sql; connect to odbc (dsn=&ds user=&us password=&pw); create table mytest.sqlo as select * from connection to odbc ( SELECT * FROM &det..&table WHERE ROWNUM <= 5 ); disconnect from odbc; quit;   The table is now created directly in the database, whereas before it was created in the work library. Thanks again. ... View more

Using SAS/ACCESS to ODBC I can select data from the DB and create tables within SAS libraries, I need to write the table directly into the Oracle database. If you have experience with ODBC and SAS, could you please help me specify the path of the libref within the database? ... View more

Hello everyone, thank you all for your help. I was able to send an email using Tom's method of xcmd by adding the 'swaks' command in the script. However, I found that when I entered the password directly in the command, I got unsuccessful authentication because the password is decoded in base64 into a different password than what I typed. To avoid this issue, I used the following command to enter the password in this format:   $(echo 'cGFzc3dvcmR4' | base64 --decode)   This is the full command I used to send the email:   x "swaks --to &rec --from &sen --server &serv --tls --auth LOGIN --port 465 --auth-user userx1 --auth-password $(echo 'cGFzc3dvcmR4' | base64 --decode) --h-Subject &subj --body &email_body --attach &attachment";   Is it possible that SAS also decoded my password into another password, which led to unsuccessful authentication? ... View more

Did you fix your SAS code to specify the FROM address? Yes, but it didn't work.   Are you sure your SAS session is running on the same machine as your test? Yes, it is the same.   Also do any of the addresses contain special characters that might make generating them from SAS tricky? Yes, the FROM address is like this: username_ab@domainx.com .   you could generate the email message first and then just call that same swaks command to send it. Could you please provide an example of how I can do that? ... View more

I tried the examples provided in the article, but I consistently encountered the same errors. but, when I tested sending a test email using the following command on the SAS compute server:   [sas@computeserver ~]$ swaks --to recipient@domainy.com --from email@domainx.com --server smtphost.domainx.com --tls --auth LOGIN --port 465   the email was successfully sent. I used the same credentials that I had previously used in the SAS program. I'm unsure what might be missing in the SAS program that prevented the email from being sent. ... View more

@ChrisHemedinger  Can you please let me know what information I should request from the person in charge of the SMTP server? ... View more

@yabwon @SASJedi  When I tried to add the following line to the options:   emailauthprotocol=Login   I got a different error message:   ERROR: Login failure ERROR: Email: 504 5.7.4 Unrecognized authentication type   Does this indicate that my login credentials are invalid? ... View more

@Sajid01 yes I am able to connect to SAS EG using sasdemo and I can run this program  proc setinit;run; without problem ... View more

Hello @Sajid01 , We are currently working with SAS 9.4 and the SAS servers are installed on Linux OS. For the OS account, we have a sas group that has sasdemo as a user. Using the same credentials of this user, we are able to access SMC. I just added sasdemo to the SAS Environment Manager groups and SAS Studio groups, but we are still unable to access SAS Environment Manager and SAS Studio. ... View more

Thank you I will try to do that ... View more

@SASKiwi Thank you for your response. This is an old SAS installation, and my goal is to learn SAS administration tasks using SAS Environment Manager. Unfortunately, I am unable to access it due to the "Invalid ID or password" error. I have already tried different browsers (Mozilla firefox and Microsoft Edge) with the same result. ... View more