Stack Overflow
Stack Overflow

Questions tagged [sas-metadata]

for questions relating to programmatic interfaces to the SAS Metadata Model

In SAS 9, metadata is stored in a repository based upon types defined in the SAS Metadata Model. One or more repositories are served by the SAS Metadata Server. Every installation of SAS BI or EBI will have a SAS Metadata Server. Metadata is managed by using SAS Management Console. Administrators may have varying levels of access to metadata and this product will enforce security restrictions.

44 questions
6
votes
1 answer

SAS, programmatically export metadata object spks

In SAS, I have a folder structure that contains a large number of SAS table metadata. To migrate from one environment to another, we need to manually create a large number of spks and push them to Git. This is problematic because it (a) takes time,…
jaamor
  • 317
  • 3
  • 15
5
votes
3 answers

User of stored process, which variable to use?

When i look in a SAS log, there are 4 different Variables to grab User: _METAPERSON _METAUSER _SECUREUSERNAME _USERNAME When i check the log, all 4 variables have the same value when i execute the process. So i builded a process which checked…
kl78
  • 1,628
  • 1
  • 16
  • 26
4
votes
1 answer

SAS Metadata DATA STEP Functions

I want to know why is the metadata_getnatr function is used with metadata_resolve function when we are trying to read the metadata through data step functions. For example: in the code that is covered in the link Reproduced Here: Example 1: Using an…
Sophiya1721
  • 41
  • 1
4
votes
1 answer

Creating Internal Accounts in SAS Metadata Server by programm on SAS Base

I'm trying to create Internal Accounts programmaticaly by using proc metadata. The code section below creates person with External Login. put""; put""; put"
Sanek Zhitnik
  • 716
  • 1
  • 10
  • 25
3
votes
1 answer

Obtaining the name of the creator of SAS VA Report from EG (metadata)

I'm trying to access the names of the creators (or person who last updated the report) of the reports in SAS VA without checking in the creators of the physical files on the server, which are not accessible for me. Is this sort of data stored in…
Łukasz Stasiak
  • 107
  • 1
  • 2
  • 11
3
votes
1 answer

Use of OMI_IGNORE_NOTFOUND flag in OpenMetadata interface

In SAS Open Metadata reference (page 126), it says: The UpdateMetadata method enables you to update the properties of existing metadata objects. It returns an error if the metadata object to be updated does not exist, unless the OMI_IGNORE_NOTFOUND…
Vasilij Nevlev
  • 1,449
  • 9
  • 22
3
votes
2 answers

How to get ID of stored process?

i have some stored processes with identical names. To identify which process is running at the moment, i need to know the id of the stored process in the metadata. Can i retrieve the STP-id somewhere? I could not find a variable which holds the…
kl78
  • 1,628
  • 1
  • 16
  • 26
3
votes
2 answers

SAS script to list all SAS server users from metadata

I need a way to import a list of all SAS users from SAS metadata into an Excel worksheet. I was considering doing this using the SAS plugin for Microsoft Office to create a dynamic data source the retrieves the list of users dynamically from the…
LokMac
  • 391
  • 2
  • 8
  • 17
2
votes
4 answers

Obtain Site Name in SAS

If we run proc setinit in SAS we can obtain the Site Name and the Site Number. The Site Number can be easily extracted using &syssite. Other than redirecting & parsing log output, is there a way to programmatically obtain the Site Name? I've…
Allan Bowe
  • 12,306
  • 19
  • 75
  • 124
2
votes
0 answers

Not able to log off user sessions in SAS

In SAS Customer Intelligence, there are user sessions under Administration tab as shown below. The problem is there are few sessions of previous day which are not getting logged of. To let you know I've already cleared all Unxsrv sessions by killing…
Aishwarya Mishra
  • 43
  • 6
2
votes
3 answers

Determining Server Context (Workspace Server vs Stored Process Server)

I'd like to conditionally execute code depending on whether I'm in a Workspace or Stored Process server context. I could do this by testing the existence of an automatic STP variable, eg _metaperson, but this wouldn't be very robust. Assuming I…
Allan Bowe
  • 12,306
  • 19
  • 75
  • 124
2
votes
1 answer

SAS Get metadata capabilities from a Role

I have a role of my system, but i need a script for get the metadata capabilities of this role. I have the URI that identify my Role, but i dont know how i can get all capabilities. thanks for your responses.
ROBY HERNAN RUBIANO
  • 157
  • 9
2
votes
2 answers

SAS Folder Path for Metadata tables

I'm wondering if anyone knows how to retrieve the sas folder path for metadata tables? I would like to list the folder path for each tables located on metadata. Example: Table FactPortfolio is under the following fodler structure in management…
user3270069
  • 31
  • 1
  • 4
2
votes
2 answers

Registering a SAS library in Metadata - programmatically

I am writing a deployment script, and would like to programmatically register a simple (and empty) BASE library, such as the one below, in Metadata. libname MYLIB 'C:\temp'; Sample XML syntax can be found here.. Am just not sure how to combine…
user2173800
  • 97
  • 3
  • 8
1
vote
1 answer

Debugging SAS error message "ERROR: Cannot retrieve metadata from SAS Metadata Repository."

I get the above error when submitting code as follows: 337 data x; 338 set nz.aa; ERROR: Cannot retrieve metadata from SAS Metadata Repository. 339 run; The NZ library is on a Netezza server accessed via UNIX (libname engine), SAS 9.1.3. Our…
Allan Bowe
  • 12,306
  • 19
  • 75
  • 124
1
2 3