@thomask23 wrote: The program works if I manually update the macro. The problem is the naming conventions will change each month. I am attempting to create a macro to execute it as a macro using a datafile. however I do not know how to run a macro using a datafile. Check the documentation for call execute. YOu can pass the filename to a macro and it will do it for you. I have a macro on my github page that does this, you can take a look at it here:   The list_files macro part you have an easier solution so use that,but the data step and macro should be similar to what you need. https://github.com/statgeek/SAS-Tutorials/blob/master/Import_all_files_one_type ... View more

If this is really an exact representation of the input and output, you could try: data want;    set have;    output;    balamt=0;    monyear='Feb-14';    output; run; Sorting might be necessary afterwards.  Good luck. ... View more

untested: CASE WHEN a.DT > '02Jan2015'd      THEN b.STAT           Else a.STAT end as STAT ... View more

Hi, If you really are new to SAS, be careful with how soon you start writing macros.  The (main) purpose of the macro language is to generate SAS code.  Usually it makes sense to spend time writing (and debugging) your own SAS code until you are comfortable with that, before adding in the complexity of automated code generation.  There is plenty you can do with SAS without worrying about macros.  Even non-macro ways to do code generation. That said, if you are sure you want to dive in to macros, sometimes a way to start is to write your SAS code first and get it working, and then convert it into a macro. --Q. ... View more

The EMAIL macro would generate the EMAIL...invoked iteratively for each EMAIL-recipient from your list (possibly a SAS file/member).  The macro would contain SAS code that likely uses FILENAME and EMAIL engine to generate your EMAILs. A DATA step would be used to drive the CALL EXECUTE processing -- you must use SAS code to build the SAS macro invocation statements as the argument passed to CALL EXECUTE. You have to start with generating / compiling your EMAIL-recipient list, either from an external information source or possibly directly from a SAS file. Suggest you search the Internet with argument "data step call execute invoke macro" for documentation / example references. Scott Barry SBBWorks, Inc. ... View more