I would like to see DI Studio topic here very much. For the first time, just create the common topic, and will see how it can be divided after users post their questions.
I have a question right now, and don't know where should I post it.
As all the metadata in DI can be produced as XML structure, there is possibility to read for example properties of tables.
Following code reads Names and Descriptions of the tables, which names contains 'abc':
filename
prop "c:\prop.xml";
filename
getProp "c:\getProp.xml";
data
_null_;
file getProp;
put '' ;
put 'SAS' ;
put '$METAREPOSITORY' ;
put 'PhysicalTable' ;
put '' ;
put '' ;
put '388' ;
put '' ;
put '' ;
put '' ;
put '' ;
put '' ;
put '' ;
put '' ;
run;
proc metadata
out=prop
header=full
in=getProp;
run;
Also, tables contains a lot of another properties, for example Note. How can I access this Note property?
This
put '' ; doesn't work.