04-08-2013 08:30 PM
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?
04-08-2013 08:41 PM
libname folder1 '...'
libname folder2 '...'
create table t1 as
create table t2 as
...(the same here)
proc compare t1 vs t2;
04-08-2013 11:53 PM
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 ?