topic Infomap with View as Source in SAS Web Report Studio

Infomap with View as Source

milts — Wed, 13 Jun 2012 03:29:18 GMT

Just curious, Is it possible to create an Infomap wherein the source is a SAS table view? or how about a Teradata table view?

Thanks!

Milton

Re: Infomap with View as Source

twocanbazza — Wed, 13 Jun 2012 03:35:41 GMT

In short Yes, You can also use a resulting data set from a stored process

Barry

Re: Infomap with View as Source

milts — Wed, 13 Jun 2012 10:04:02 GMT

Thanks for the info Barry. Is this on latest version of SAS?

Milton

Re: Infomap with View as Source

twocanbazza — Thu, 14 Jun 2012 02:17:37 GMT

Hi Milton.

I know it can be done on SAS9.2 and the corresponding Clients - assume 9.3 also

Cheers

Barry

Re: Infomap with View as Source

milts — Wed, 20 Jun 2012 02:49:55 GMT

Thanks again Barry. But is it correct that it's slower when I have a view instead of a physical table for my InfoMap?

Thank!

Milton

Re: Infomap with View as Source

LinusH — Wed, 20 Jun 2012 08:01:18 GMT

Bellow discussion has little to do with InfoMaps.

Well, views might be slower, but in many cases, the user doesn't experience any difference.

it depends on what the view does. Any ordering, summarization and joining will obviously make the view slower than a corresponding table.

If the source tables to the view have indexed columns, it's not sure that the view can merge the where-clauses in the view with a where clause from the calling program (in this case, the Infomap).

Re: Infomap with View as Source

SuneelReddy — Fri, 29 Jun 2012 06:51:49 GMT

Yes. you can create Infomap using different different source tables. like 1) Stored Process 2) Dataset and can be done in 9.1 version also.

If you are creating views, you cant filter the data as of my knowledge.

Regards,

Suneel