topic Re: How do I compare two libraries? in SAS Programming

How do I compare two libraries?

kyle234 — Thu, 02 May 2024 13:30:59 GMT

I would like to compare two libraries. They have similar tables and I would like to compare the data types of fields in the tables? How do I go about doing this?

Re: How do I compare two libraries?

kyle234 — Thu, 02 May 2024 13:34:43 GMT

I would like to do it for 30 tables. Thank you

Re: How do I compare two libraries?

data_null__ — Thu, 02 May 2024 14:17:41 GMT

This may be close to what you are looking for.

proc datasets kill;
   copy in=sashelp out=work;
   select class classfit shoes cars;
   run;
   contents data=work._all_ noprint out=workvars;
   run;
   quit;
proc sort data=workvars;
   by name type;
   run;
proc transpose data=workvars out=wide;
   by name;
   var type;
   id memname;
   run;
proc print;
   run;