SAS SPDS9 files comparition

[maheshsompalli]

how to compare two SPDS9 files using SAS Procedures.

or

how to convert SPDS files to SAS Datasets.

[ChrisNZ]

1. proc compare is the data comparison utility in SAS. The underlying data engine does not matter.

2. proc copy from a SPDE library to a V9 library.

SPDE tables tables present many advantages over V9 tables though, so be sure that's actually what you want.

[maheshsompalli]

So this means, we use Proc Copy to convert SPDS files to normal SAS Datasets. or using libname <libref> SPDE <path> can also produce the same result? I have a small doubt in it.

[LinusH]

You can't compare <files> using PROC COMPARE, it will compare the data set as an object, regardless of the physical files. But perhaps you mean data sets/tables rather than files?

[maheshsompalli]

So this means, we use Proc Copy to convert SPDS files to normal SAS Datasets. or using libname <libref> SPDE <path> can also produce the same result? I have a small doubt in it.

[ChrisNZ]

libname A base 'path';

libname B spde 'path'; /* can be the same path */

proc copy from B to A