topic Re: Oracle Index to Sas Pass through in SAS Enterprise Guide

Oracle Index to Sas Pass through

SASNE — Fri, 17 Feb 2017 01:53:58 GMT

Hi Gurus,

Would like to ask if the Oracle index will pass to SaS when i extract data from Oracle ?

or i need to create index again after extracting dataset from Oracle ?

Thanks

Re: Oracle Index to Sas Pass through

SASKiwi — Fri, 17 Feb 2017 02:51:56 GMT

No. You will have to re-create the index in SAS.

Re: Oracle Index to Sas Pass through

SASNE — Fri, 17 Feb 2017 03:59:49 GMT

Thank you for your help SasKiWi, one more question do you know how to create index in EG ?

thanks

Re: Oracle Index to Sas Pass through

LinusH — Fri, 17 Feb 2017 07:19:02 GMT

No Enterprise Guide specifics. Read online doc SAS Language concepts as introduction. If you are familiar with SQL I suggest that start trying using that.