11-08-2024
holcoje
Calcite | Level 5
Member since
05-21-2018
- 5 Posts
- 0 Likes Given
- 0 Solutions
- 0 Likes Received
-
Latest posts by holcoje
Subject Views Posted 474 07-22-2024 01:13 PM 1450 01-23-2024 08:03 AM 1517 01-22-2024 02:21 PM 403 03-21-2022 02:56 PM 7846 10-21-2019 01:01 PM -
Activity Feed for holcoje
- Posted Can I use a group member's User ID in the logic for a stored process on SAS Programming. 07-22-2024 01:13 PM
- Posted Re: How to edit, delete, and append records on SQL Server on SAS Programming. 01-23-2024 08:03 AM
- Posted How to edit, delete, and append records on SQL Server on SAS Programming. 01-22-2024 02:21 PM
- Posted Making changes to values in SQL Server table based on records in SAS table on SAS Programming. 03-21-2022 02:56 PM
- Posted Sending email via SAS with .xlsx attachment on SAS Enterprise Guide. 10-21-2019 01:01 PM
07-22-2024
01:13 PM
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
01-23-2024
08:03 AM
I am familiar with PROC SQL. But in order to make those changes directly to the SQL Server DB, I would need to connect to the table with a passthrough, correct? For security, operations is not providing is with the username and password for the SQL Server database. We have a continuous connection as a LIBNAME statement.
... View more
01-22-2024
02:21 PM
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
03-21-2022
02:56 PM
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
10-21-2019
01:01 PM
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
Labels: