Check out the Dictionary Tables, most metadata can be extracted from them. I'm not sure what "compiled modules" you're referring to and have no experience, but most things like this I've needed have been found in the Dictionary tables. Search the online doco for Proc SQL, you should find some help there.
Chris
Business Analyst, Code Monkey, Data Wrangler.
SAS Guru.