BookmarkSubscribeRSS Feed
Ashish_S
Fluorite | Level 6

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

4 REPLIES 4
Ashish_S
Fluorite | Level 6

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
Super User

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
Garnet | Level 18

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
Diamond | Level 26 RW9
Diamond | Level 26

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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 955 views
  • 0 likes
  • 4 in conversation