The SAS Output Delivery System and reporting techniques

How to Find the redundant report from prod

Reply
New Contributor
Posts: 2

How to Find the redundant report from prod

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

New Contributor
Posts: 2

How to find the redundant report from prod

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

Grand Advisor
Posts: 17,313

Re: How to find the redundant report from prod

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. 

Super User
Posts: 1,226

Re: How to Find the redundant report from prod

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)

Esteemed Advisor
Esteemed Advisor
Posts: 7,192

Re: How to Find the redundant report from prod

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

Ask a Question
Discussion stats
  • 4 replies
  • 214 views
  • 0 likes
  • 4 in conversation