DATA Step, Macro, Functions and more

ORACLE 'anydata' type

Regular Contributor
Posts: 163

ORACLE 'anydata' type

anybody know of a way to read Oracle's 'anydata' type?
Super User
Posts: 5,700

Re: ORACLE 'anydata' type

Using the Anydata data type means that you can store data of different types in a single column. Beats my when this comes in handy.

There is no automatic support for this in SAS/ACCESS. To read this data you need to create (if not already exists at your site) wrapper functions to call the appropriate methods that can sort out which data type the actual value is stored. See this blog:

To this data SAS, I can only guess. You might be able to create a view in Oracle that SAS is able read using the wrapper function. You might even be able to use SQL pass-thru for this. It would be interesting to hear if you could make this work.

Data never sleeps
Ask a Question
Discussion stats
  • 1 reply
  • 2 in conversation