METADATA Procedure

Example 7: Request the Metadata for One Object

Procedure features:

IN= argument

Other features:

<Flags> element

Program

proc metadata
     in='<GetMetadata>
         <Metadata>
            <PhysicalTable Id="A58LN5R2.AR000001"/>
         </Metadata>
         <Ns>SAS</Ns>
         <Flags>1</Flags>
         <Options/>
         </GetMetadata>';
run;

SAS Log

NOTE: Response XML:

<GetMetadata><Metadata><PhysicalTable Id="A58LN5R2.AR000001" ChangeState="" 
DBMSType="" Desc="" IsCompressed="0" IsDBMSView="0" IsEncrypted="0" LockedBy="" 
MemberType="DATA" MetadataCreated="17Oct2006:20:54:16" 
MetadataUpdated="17Oct2006:20:54:17" Name="INVENTORY" NumRows="-1" PublicType="" 
SASTableName="INVENTORY" TableName="INVENTORY" UsageVersion="0"><AccessControls/>
<Aggregations/><AnalyticTables/><AssociatedXMLMap/><Changes/><Columns>
<Column Id="A58LN5R2.AS000001" Name="Product" Desc=""/><Column Id="A58LN5R2.AS000002"
Name="Test1" Desc=""/><Column Id="A58LN5R2.AS000003" Name="Test2" Desc=""/>
<Column Id="A58LN5R2.AS000004" Name="Final" Desc=""/></Columns><CustomAssociations/>
<Documents/><Extensions/><ExternalIdentities/><ForeignKeys/><Groups/><Implementors/>
<Indexes/><Keywords/><LocalizedAttributes/><ModelResults/><Notes/>
<PrimaryPropertyGroup/><Prompts/><Properties/><PropertySets/><ReachThruCubes/>
<ReferencedObjects/><ResponsibleParties/><Roles/><SASPasswords/>
<SourceClassifierMaps/><SourceTransformations/><SpecSourceTransformations/>
<SpecTargetTransformations/><TableCollections/><TablePackage>
<SASLibraryId="A58LN5R2.AP000001" Name="blue" Desc="This is in the c:/blue directory 
and its SAS libname is MYFILES"/></TablePackage><TargetClassifierMaps/>
<TargetTransformations/><Timestamps/><TrainedModelResults/><Trees/>
<TSObjectNamespace/><UniqueKeys/><UsedByPrototypes/><UsingPrototype/><Variables/>
<XPaths/></PhysicalTable></Metadata><Ns>SAS</Ns><Flags>1</Flags><Options/>
</GetMetadata>

Top of Page