Count all created/referenced tables in a SAS Program

[MajorJohnny]

Hi all,

I'm working as an intern in a financial institution. I had to pick up SAS rather quickly, so basically I'm a total noob.

We are using absolutely massive SAS programs, referencing and creating a lot of tables in them. My question is if there is a way to count the number of all created/referenced tables in a single program, since manually it would take ages.

Also is there such a term as "historical tables"? Is there a difference between "historical table" and a simple table? I can't find any information on that.

Thanks!

[Jagadishkatam]

You can try to find the number of datasets being called, by searching the text starting with 'data' or 'set' and if proc sql is also used then try to search for text 'table as ' or 'from' because anything after these text will be a dataset name. Also, there is nothing like historical tables or simple tables in SAS, it depended on the data what you are analyzing, if your company data is old and that you are working on then it is called as historical tables

[AhmedAl_Attar]

@MajorJohnny 

Try using the SCAPROC Procedure, it will analyze the code for you.

Here is a paper about it Thoroughly Modern SAS : The SAS Code Analyzer Helps Bring Programs Up to Date

Hope this helps,

Ahmed