Hello, I have 2 small data steps to retrieve a tableUri from the metadata. I'm 100% sure that both objects exist in the metadata and they both have a unique URI. I checked in the management console.
Dataset temp gives me a blank tableUri and an rc-4. Dataset temp2 gives me the correct tableUri and an rc 1.
So my code is working, but for the library MW Cross Business Staging i'm not getting any results. The security is set in the same way and i'm a SAS Admin at my client. Any ideas of what the problem may be?
data temp;
format searchUri tableUri $256.;
searchUri = cats("omsobj:DataTable?DataTable[@Name = 'FEEL_LABELS_Omschr']",
"[TablePackage/DatabaseSchema[@Name = 'MW Cross Business Staging']");
rc = metadata_getnobj(searchUri, 1, tableUri);
run;
data temp2;
format searchUri tableUri $256.;
searchUri = cats("omsobj:DataTable?DataTable[@Name = 'FEEL_LABELS_Omschr']",
"[TablePackage/DatabaseSchema[@Name = 'MW Measure Business Staging']");
rc = metadata_getnobj(searchUri, 1, tableUri);
run;