BookmarkSubscribeRSS Feed
beta3badri
Calcite | Level 5

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.

1 REPLY 1
ballardw
Super User

@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.

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 609 views
  • 0 likes
  • 2 in conversation