Export data from information map studio to text file

grudos20 — Fri, 10 Feb 2023 10:06:02 GMT

Hello dear sas users!
Please tell me how to output data from the Infromation Map Studio application, for example, to a csv file.
I really need data on attributes and their relationship with attributes from the data source. My data source is Oracle Data Base.
Using the example of one attribute, when I open detailed information (see the screenshot), I want to get the following data:
1. data item name
2 Location
3.Description
4 Expression

Does anyone have any options on how to do this?

Re: Export data from information map studio to text file

KatS_SAS — Wed, 22 Feb 2023 17:46:37 GMT

Hello Grudos20,

There is not an easy way to get the data items detail from the Information Map studio. You can use PROC INFOMAPS and the LIST statement to write that information to a file and then read in that file using other SAS code. You can use PROC DOCUMENT to render the ODS output to a CSV file by reading in the log that is generated to a file.

/* Redirect the log to a file*/
proc printto log="c:\temp\tempmap.log"; run;

/* Run Proc Infomaps to list the dataitems information */
proc infomaps
  metauser="sasdemo"
  metapass="XXXXXXX"
  metaserver="machine.com"
  metaport=8561
  mappath="/Shared Data/Information Maps/";
update infomap "Prdsale Map";
list; 
save;
quit;

/* Turn off the Proc Printto */
proc printto; run;

/* Proc Document to read in the log file and write it to a CSV file using ODS */
proc document name=logfile(write);
import textfile="c:\temp\tempmap.log" to ^;
run;

ods csv file="c:\temp\map.csv";
replay;
run;
quit;
ods csv close;

I have included links to some documentation as well.

Documentation to Proc Infomaps

Documentation to Proc Document

topic Re: Export data from information map studio to text file in SAS Enterprise Guide

Export data from information map studio to text file

Re: Export data from information map studio to text file