Retrieving tableUri from the metadata

Filipvdr — Fri, 23 Nov 2018 15:54:20 GMT

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;

Re: Retrieving tableUri from the metadata

Filipvdr — Fri, 07 Dec 2018 13:59:00 GMT

We found the issue.

When creating the library we copied text from excel to SAS Management Console. There was a character which we could not see.

When looking into the SAS metadata browser we saw the libraries were not sorted correctly.. that's how we discovered

topic Re: Retrieving tableUri from the metadata in Administration and Deployment

Retrieving tableUri from the metadata

Re: Retrieving tableUri from the metadata