Daily report automation

[BrahmanandaRao]

Hi friends 

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

[Reeza]

Your question is fairly broad, so is the answer. 

For reporting in general, you need to learn:

1. Summarize data procs: means, summary, univariate, freq, tabulate
2. Present data: print, report, tabulate, data step
3. Output destinations: ODS statements such as Excel, PDF, Word/RTF and data _null_
4. 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

[Kurt_Bremser]

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

[BrahmanandaRao]

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

[Kurt_Bremser]

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

[Reeza]

What is missing from my original answer?

[SASKiwi]

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=n0x9...

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.