Help using Base SAS procedures

Compare 2 datasets

Reply
Occasional Contributor
Posts: 11

Compare 2 datasets

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...
Respected Advisor
Posts: 3,887

Re: Compare 2 datasets

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
N/A
Posts: 0

Re: Compare 2 datasets

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
Ask a Question
Discussion stats
  • 2 replies
  • 134 views
  • 0 likes
  • 3 in conversation