How to Find the redundant report from prod

[Ashish_S]

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

[Ashish_S]

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

[Reeza]

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. 

[Shmuel]

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)

[RW9]

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