topic Re: Compare 2 datasets in SAS Procedures

Compare 2 datasets

Jackie_Stanbank — Mon, 03 May 2010 09:39:51 GMT

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...

Re: Compare 2 datasets

Patrick — Mon, 03 May 2010 11:09:30 GMT

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

Re: Compare 2 datasets

deleted_user — Mon, 03 May 2010 11:43:28 GMT

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