any macros to list two folder's data file list and compare their contents?

[ZRick]

I have a production environment and dev environment, folder structure are almost identical.

I need to constantly compare the data in the development folder vs in the production folder.

For example, I have dev folder, /dev, production folder /prod, both have at least dozen files.

how do I do a proc compare on those two folders without manually input what data file is compared with what data file?

I have the proc compare macro, but I don't know how to dynamically generate a two columns of tables and read it using the loop to do the macro.

any test code/suggestions?

[SandyH]

libname folder1 '...'

libname folder2 '...'

proc sql;

     create table t1 as

    select memname

   from dictionary.tables

   where upcase(libname）=folder1

   create table t2 as

   ...(the same here)

quit;

proc compare t1 vs t2;

[Sudhakar_A]

Hi,

just a clarification about your question. Do you need to compare the filenames between two folders? or to compare the datasets in both the folders ?

Sudhakar

[Ron_MacroMaven]

This page has programs which return lists of various items

http://www.sascommunity.org/wiki/Making_Lists

Ron Fehd  lists maven