topic Re: Opening Information map thru EG in SAS Enterprise Guide

Opening Information map thru EG

kedar — Sat, 06 Nov 2010 19:20:29 GMT

I am opening Information map contains 5 colums thru EG. It's not opening the information map. But when i ignore some column name from information map i can view it. what could be the problem? if it's authorization issue where we can check it?

Re: Opening Information map thru EG

Patrick — Sun, 07 Nov 2010 13:30:48 GMT

Hi

One reason could be that the information map (meta data column definitions) is not in sync with the physical SAS table (i.e. column doesn't exist in the SAS table or has another name or data type).

"if it's authorization issue where we can check it?"
SAS Management Console for metadata, OS tools for the file system (the actual SAS tables), DB tools if it's a DB table.

What does the SAS log tell you?

There might also be some information available in one of the Server logs. Not sure in which one it would show (metadata server, workspace server, object spawner).

First thing I would try: Can you access all columns directly via EG not using the information map (just submitting a similar query). If yes then I would continue to look for metadata out of sync.

HTH
Patrick

Message was edited by: Patrick

Re: Opening Information map thru EG

ChrisHemedinger — Sun, 07 Nov 2010 17:04:58 GMT

Another way to check the content: see what you can see when you report on the contents of the information map using this program:

http://blogs.sas.com/sasdummy/index.php?/archives/177-Reporting-on-SAS-Information-Maps.html

Chris