topic Re: How to Find the redundant report from prod in ODS and Base Reporting

How to Find the redundant report from prod

Ashish_S — Wed, 16 Nov 2016 08:28:51 GMT

Hi All,

Could you please help me to know, if there is any tool or code in SAS that can be used to find all redundant SAS reports.

Requirement: In Production, we have 800-1000 SAS report and we need to find the reports which are necessary so the redundant report needs to be removed (for ex. If report is not getting updated etc).

Need your quick assistance on this.

Regards,
Ashish S

How to find the redundant report from prod

Ashish_S — Wed, 16 Nov 2016 08:27:02 GMT

Hi All,

Could you please help me to know, if there is any tool or code in SAS that can be used to find all redundant SAS reports.

Need your quick assistance on this.

Regards,
Ashish S

Re: How to Find the redundant report from prod

Shmuel — Wed, 16 Nov 2016 08:51:18 GMT

To scan the sas reports and check for last date created you need to know:

1) how shall you recognize SAS REPORT - are those .lst files ? or maybe .pdf files ? or other suffix (like htm) ?

2) are the reports in specific directory ? few directories? or spread all over the disk space ?

3) what OS are you using ? Windows / UNIX or Linux ?

4) what are the criterions to delete redundant reports ? do you need a backup ?

5) would you prefer system tools to search and (backup) and delete

or do it by SAS tools (a tailored program)

Re: How to find the redundant report from prod

Reeza — Wed, 16 Nov 2016 08:51:21 GMT

Not really as that's business logic not code logic. Depending on what exactly you call a report and how you distribute it perhaps you can track usage? Are you using Web Report Studio or some other mechanism to distribute your reports?

Perhaps you can look at the code or stored processes to see the last time something was modified and flag older ones to be checked. Either way, there's going to be a need to liase with your end users to determine what is redundant and what's not.

Re: How to Find the redundant report from prod

RW9 — Wed, 16 Nov 2016 10:11:58 GMT

Define "necessary" and "redundant" in logical terms, i.e. if someone new joined and you had to explain it.