I have a list of 30 jobs running on a certain day of the month. So I wanted to build a sas code which is kind of like a summary that shows the JOBNAME, RUNDATE AND MONTH AND THE NUMBER OF EXCEPTIONS in all of them individually and I want this job to run every month so that I have a single file which has the report details. How do I go about doing this? Please suggest. If you have done it anytime, could you please share some code.
@beta3badri wrote:
I have a list of 30 jobs running on a certain day of the month. So I wanted to build a sas code which is kind of like a summary that shows the JOBNAME, RUNDATE AND MONTH AND THE NUMBER OF EXCEPTIONS in all of them individually and I want this job to run every month so that I have a single file which has the report details. How do I go about doing this? Please suggest. If you have done it anytime, could you please share some code.
Where is that information stored? Is it in a SAS data set? External file? How to determine if any, and how many, exceptions occurred may be needed. An example of the data would be helpful.
Typically with something of this nature gathering the information is the hard part. Reporting counts within a time frame by grouping variables is generally pretty straight forward.
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.