Fran

I'm pretty sure that you could do this with SQL but it might be easier to use Proc Contents and specify an output data set.

Nat Wooding

-----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of franwdwyer@googlemail.com Sent: Monday, April 12, 2010 1:29 PM To: SAS-L@LISTSERV.UGA.EDU Subject: Code to export variable attributes of all datasets in a library to Excel

Hi everyone,

I'm sure this has been done very often and must be in some paper / page on the internet but I cannot find anything.

Could anyone point me to where I could find code that exports the variable attributes of all datasets in a folder to an Excel file.

Thanks in advance for any suggestions,

Best regards,

Fran CONFIDENTIALITY NOTICE: This electronic message contains information which may be legally confidential and or privileged and does not in any case represent a firm ENERGY COMMODITY bid or offer relating thereto which binds the sender without an additional express written confirmation to that effect. The information is intended solely for the individual or entity named above and access by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution, or use of the contents of this information is prohibited and may be unlawful. If you have received this electronic transmission in error, please reply immediately to the sender that you have received the message in error, and delete it. Thank you.