Sorry, I just dump some code fragments: %macro procmeta(user=DWH, passwd={sas001}xxx, in=query, /* Filereferenz auf XML Datei mit Metadaten*/ out=tmpout); proc metadata SERVER = "sas-meta.corp.de" PORT = 8561 REPOSITORY = "KPI" USERID = "&user" PASSWORD = "&passwd" IN = &in OUT = &out ; run; %mend procmeta; This Macro can query the metadataserver. For IN use some TXT file like this one: data _null_; file query; input; put _infile_; datalines; <GetMetadataObjects> <Reposid>$METAREPOSITORY</Reposid> <Type>Tree</Type> <Objects> <Tree Name="KPI"/> </Objects> <Ns>SAS</Ns> <Flags/> <Options> <Templates> <Physicaltable/> </Templates> </Options> </GetMetadataObjects> ;; run;
... View more