topic Re: Daily report automation in SAS Programming

Daily report automation

BrahmanandaRao — Thu, 15 Oct 2020 16:19:51 GMT

Hi friends

how to generates daily, weekly ,monthly reports (batch files) any tutorials please help

Re: Daily report automation

Reeza — Thu, 15 Oct 2020 16:58:19 GMT

Your question is fairly broad, so is the answer.

For reporting in general, you need to learn:

Summarize data procs: means, summary, univariate, freq, tabulate
Present data: print, report, tabulate, data step
Output destinations: ODS statements such as Excel, PDF, Word/RTF and data _null_
Automated reporting issues such as:
- ensuring all categories show up in reports (missing levels or months?)
- how to handle missing data/present
- data suppression - we often have to mask data for confidentiality
- historical accuracy - does the report need to match previous data or is a full refresh every cycle
- invalid parameters entered
- empty files

Assuming that's all known and you're looking at just technical reporting here's a rough example.

https://gist.github.com/statgeek/353374a5d8ea4f0c89ce5d80a47f4a4c

You can also search out the LexJansen.com website for examples as that has a ton of user written papers and posts on the topic.

https://www.lexjansen.com/search/searchresults.php?q=reporting%20tutorials

Re: Daily report automation

Kurt_Bremser — Fri, 16 Oct 2020 14:24:25 GMT

As noted, this question is much too broad. Possible answers depend largely on your environment.

which operating systems are involved
is SAS installed stand-alone or in a BI server setting (metadata or no metadata)
which scheduling tools are available
is simple time-dependent scheduling enough, or need external triggers be honored, or are there dependencies between multiple jobs

Reporting mails

BrahmanandaRao — Fri, 16 Oct 2020 16:36:28 GMT

What is batch file to genarates daily weekly monthly aumation reports how to write code pls hep any tutorials

Re: Reporting mails

Kurt_Bremser — Fri, 16 Oct 2020 17:14:36 GMT

Please do not repost identical questions, instead provide information as requested.

Re: Reporting mails

Reeza — Fri, 16 Oct 2020 17:41:10 GMT

What is missing from my original answer?

Re: Reporting mails

SASKiwi — Fri, 16 Oct 2020 23:18:08 GMT

If you are unfamiliar with SAS running in batch mode this link may help: https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.5&docsetId=hostunx&docsetTarget=n0x9esc5c95qg4n1wogx5u2k7354.htm&locale=en

A SAS batch program is just a SAS program stored in a text file and in batch mode you run the actual file instead of opening it SAS EG or SAS Studio and running the code in the file there.