I have a group in SAS Management Console 9.4 with a list of users. That group is given authorization to run a stored process that generates a report. Is there a way to use the USER ID of the group member in the stored process SAS code? My end goal is to append the USER ID to the name given to the log file when it is saved so that each user has a unique log file that is overwritten each time he/she runs the report.    So, if Jon Holcomb submits the stored process to generate a report, can I use his USER ID (jon.e.holcomb) in the logic of the stored process?       ... View more

Long time SAS user but new to SQL Server. Current project requires I make edits of records, deleting records, and appending records to existing tables in a SQL Server database. I have a LIBNAME connection to the database, and can read in tables to SAS no problem. Will I be able to do my edits, deletes, and appends to the tables with the normal SAS DATA step and other PROCEDURES? My first thought was to just bring the table into SAS, make all necessary edits, deletes, and appends, then replace that table in SQL Server with the SAS table, but I've been told I am not allowed to delete and create tables in SQL Server, only make changes to the existing tables.        ... View more

I have a SAS table that is a subset of records (10 records) from a SQL Server table (20,837 records). I need to update the value of a column in the SQL Server table, but only for the records that also exist in my aforementioned SAS table.    Specifically, if the record exists in the SAS table, then change the HISTORY_DATE value in the SQL Server table to today's date.    What would be the cleanest way to do this?  ... View more

I'm trying to send an email in SAS with an excel file attachment. As written, I get no errors but I do not receive the email at all. If I comment out the ATTACH statement, then the email does send, obviously without the attachment, I just receive the body of the email. SAS is installed on a Linux server, I'm using SAS EG on a virtual windows desktop. I have had no problems sending image attachments of charts and graphs with similar code. Can anyone see a reason why I'm not receiving my email in this case?    options emailhost=smtp.test.test.test; filename mailbox email ('test@mail.test') attach=("/directory/file.xlsx" content_type="application/vnd.ms-excel") subject = "Email Subject" content_type="text/html"; ods listing close; ods html body=mailbox; data _null_; file print; put "This is an automated email. Please do not reply"; run; ods html close ... View more