Compare 2 datasets

[Jackie_Stanbank]

I want to compare the variable names as well as the vaiable formats of two datasets within SAS without doing a PROC CONTENT on each as there are over 500 variables in each table.

I can also do a PROC APPEND, but that is not the proper way.

please help...

[Patrick]

Hi

The information you need to do such a comparison is stored in SAS dictionary tables.

If you're using PROC SQL you can use dictionary.columns, else you could use the view SASHELP.VSCOLUMN

HTH
Patrick

[deleted_user]

Hi

You may prefer to use PROC COMPARE with NOVALUES as options.

proc compare base=sas_dataSet_1 compare=sas_dataset_2 briefsummary;
run;

Regards