About tbellmer_wf

tbellmer_wf · ‎02-19-2022

Thanks Quentin, I like the idea overall. Our SAS server is on Linux - is there a way to maybe create a new email account for this purpose and instead of using MS Outlook, have the emails go to some Outlook equivalent email on the Linux box? I do not think I can set an Outlook rule that will route the email back to the Linux box but then again, I have not tried it either. Point is, I guess there is no way to have another FILENAME / FILE combo to write out the generated email within SAS. I know this is an odd request but I can see the value in storing selecting emails to ensure everyone got it and to historically reference them for audit purposes. This is a new requirement and I of course would like to automate the entire task...

tbellmer_wf · ‎02-18-2022

I can easily generate HTML based emails with logos and attachments. Yesterday I was requested to capture a copy of selected emails (for audit purposes) and one suggestion was to get a new email account to log and save the emails to a folder. Sounds good but not sure if or how long it might take to get a new email account and to then be able to redirect the email to a folder and give it an unique name. While I know I can use multiple filenames to write out content, I am afraid the use of all those email statements that start with EM_ are too specific to make this work as expected. I mean think about how to store say an Excel file if it is not using the email engine.

tbellmer_wf · ‎06-27-2021

See sample code in this blog post that makes use of a hash object: https://kansascode.blogspot.com/2021/06/creating-sample-data.html How can this code be rewritten so that everything runs in a CAS session - all in memory - that is eliminate the hash object since we are already in memory?

tbellmer_wf · ‎06-22-2021

%macro mymacro(part1yesorno, part2yesorno); %if %upcase(%substr(&part1yesorno, 1, 1)) = Y %then %do; /* your part1 code goes here */ %end; %if %upcase(%substr(&part2yesorno, 1, 1) = Y %then %do; /* your part2 code goes here */ %end; %mend; %mymacro(Yes, No);

tbellmer_wf · ‎01-24-2018

Oh but it actually does as I use this all the time. Apparently there are a few caveats so be sure to read this note: http://support.sas.com/kb/59/744.html

tbellmer_wf · ‎01-23-2018

Feel free to modify as you desire. I needed to do that for my purposes.

tbellmer_wf · ‎01-23-2018

%macro pgmname() ; %local retval ; %let retval = %sysfunc( getoption( sysin ) ) ; /* batch mode */ %if %isblank( &retval. ) %then %let retval = &_SASPROGRAMFILE ; /* interactive mode */ /* next line removes single quotes produced in interactive mode */ %qsysfunc( compress( &retval., %str(%') ) ) %mend ;

tbellmer_wf · ‎04-02-2017

If I just had numeric columns I could do something like this using proc means: proc means data = x ; var _numeric_ ; run ; I am guessing that proc FREQ might be the best but thought I would check and see what other come up with on this board.

Online Status	Offline
Date Last Visited	‎06-15-2022 07:05 PM

Re: Send Email with attachments but also keep copy on file folder?

Send Email with attachments but also keep copy on file folder?

Revise SPRE code to run in CAS?

Re: Macro - Conditionally Process some code

Re: How to get the name of programming being executed in SAS EG 6.1

Re: How to get the name of programming being executed in SAS EG 6.1

Re: How to get the name of programming being executed in SAS EG 6.1

Most efficient way to get missing and total count of CHAR vars?

CASL: Parallel CAS Action Execution

Revise SPRE code to run in CAS?

Re: Macro - Conditionally Process some code

Re: How to get the name of programming being executed in SAS EG 6.1

Re: Send Email with attachments but also keep copy on file folder?

Send Email with attachments but also keep copy on file folder?

Revise SPRE code to run in CAS?

Re: Macro - Conditionally Process some code

Re: How to get the name of programming being executed in SAS EG 6.1

Re: How to get the name of programming being executed in SAS EG 6.1

Re: How to get the name of programming being executed in SAS EG 6.1

Most efficient way to get missing and total count of CHAR vars?