topic Re: How to create an index in SAS Programming

How to create an index

shlomiohana — Sun, 24 Apr 2022 20:09:47 GMT

Hello,

Today I use SAS Enterprise Guide 7.15 on a Linux server.

I need to create a table with an index to the windows server I run the following code:

libname tavtdata "/cifs/sastest2012 ";

data tavtdata.areamatch (outrep=windows_64);
set tavtdata.areamatch;
run;

data tavtdata.areamatch (outrep=windows_64 index=(areaCode));
set tavtdata.areamatch;
run;

The error obtained in creating the index:

I will ask for your help on how to create an index in Linux and the table will be windows_64.

Thanks.

Re: How to create an index

Tom — Sun, 24 Apr 2022 20:16:01 GMT

What you are trying to do does not make much sense. That and the fact that it is probably impossible is probably why it does not work.

If you want to make an index you have to do with a native format file.

Why do you want to make the dataset in a format that is not native to the version of SAS you using.

Why do want to make an index?

Why not just sort the data instead?

Re: How to create an index

shlomiohana — Sun, 24 Apr 2022 20:30:19 GMT

There is a system that is on a windows server until today my Guide was on a windows server so I had no problem running the code I attached, but now my Guide is on a Linux server and I need to create this table with an index, but the system is on the windows server does not accept the index created in Linux, so I used the option outrep = windows_64 so that the output would be in windows and not in Linux.

Re: How to create an index

SASKiwi — Mon, 25 Apr 2022 01:01:34 GMT

It is still not clear what you are trying to do here. Are you trying to share a SAS data library between Linux and Windows? The LIBNAME you use suggests you are storing it in a Linux folder. Was this library first created on Windows?

EDIT: I'm guessing that your original library is simply a copy from Windows in CEDA-format for cross-platform compatibility. Creating a new Linux-specific library should solve your problem:

libname tavtdata "/cifs/sastest2012 ";
libname tavtdatl "/cifs/linux/sastest2012 ";

data tavtdatl.areamatch (index = (areacode));
set tavtdata.areamatch;
run;

Re: How to create an index

andreas_lds — Mon, 25 Apr 2022 05:21:46 GMT

So you have two sas environments running on different operating systems.

I would just drop the idea of creating an index and sort the data. Then you will have a more or less increase of runtime depending on the system you are using the data, but this is the only way i can think of, that allows using one dataset on two different os.

Re: How to create an index

Kurt_Bremser — Mon, 25 Apr 2022 05:49:17 GMT

@shlomiohana wrote:

There is a system that is on a windows server until today my Guide was on a windows server so I had no problem running the code I attached, but now my Guide is on a Linux server and I need to create this table with an index, but the system is on the windows server does not accept the index created in Linux, so I used the option outrep = windows_64 so that the output would be in windows and not in Linux.

So create the index on the Windows server after moving the file there, if simply sorting is not an option.