topic Index files on sas datasets in SAS Programming

Index files on sas datasets

vijayanand — Tue, 21 May 2019 13:52:20 GMT

Hi,

I am migrating an indexed sasdataset from an AIX server to a Linux server , using PROC DOWNLOAD. The data file got migrated but not the index file. Even with PROC CPORT and CIMPORT , the index file was not migrated. The index file is physically present on the AIX server along with the data file.

On further investigation into the results of Proc Contents on this dataset, it says that Indexes 0, which means there is no index defined on this dataset.

Though the index file is physically present, is it that the index file has no connection with the data file and the index file is of no use.

Thanks,

Vijayanand.

Re: Index files on sas datasets

tsap — Tue, 21 May 2019 14:55:49 GMT

Can you show the logic used when you ran the PROC DOWNLOAD, PROC CPORT, PROC CIMPORT steps?

Re: Index files on sas datasets

Kurt_Bremser — Tue, 21 May 2019 17:38:50 GMT

Index files are highly version- and platform-specific and must be rebuilt on the target platform.

Even PROC MIGRATE does not migrate indexes, it rebuilds them.

You need to make an inventory of indexes so you can rebuild them on the target platform.

Re: Index files on sas datasets

LinusH — Tue, 21 May 2019 20:43:53 GMT

PROC DOWNLOAD supports recreation of indexes, but behaviour depend on how you are using the OUT=, DATA= and INDEX = options.

https://documentation.sas.com/?docsetId=connref&docsetTarget=n01xxs4f7yb4cln188odwmewp98x.htm&docsetVersion=9.4&locale=en#n0y1aj2ak4zismn1h0lpo16ystwh