topic Re: SAS SPDS9 files comparition in SAS Programming

SAS SPDS9 files comparition

maheshsompalli — Mon, 03 Dec 2018 20:19:49 GMT

how to compare two SPDS9 files using SAS Procedures.

how to convert SPDS files to SAS Datasets.

Re: SAS SPDS9 files comparition

ChrisNZ — Mon, 03 Dec 2018 22:16:41 GMT

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.

Re: SAS SPDS9 files comparition

LinusH — Tue, 04 Dec 2018 09:50:48 GMT

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?

Re: SAS SPDS9 files comparition

maheshsompalli — Tue, 04 Dec 2018 20:31:13 GMT

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.

Re: SAS SPDS9 files comparition

maheshsompalli — Tue, 04 Dec 2018 20:31:31 GMT

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.

Re: SAS SPDS9 files comparition

ChrisNZ — Tue, 04 Dec 2018 20:53:08 GMT

libname A base 'path';

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

proc copy from B to A