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
1
vote
1 answer

Adding new Sas users to existing Groups in Sas metadata

I am trying a similar approach to add new sas users to sas metadata and assigning them the existing groups in sas metadata. Do you have to pass the object reference values in %mm_adduser2group(user="",group="") macro provided in the GitHub link.…
Sarvesh Bhogale
  • 13
  • 2
1
vote
0 answers

sas metadata user synchronization with more repository

I have an environment with 2 repositories: Foundation: User \ Group (same as LDAP users) [Repository 2]: access group and ACT Normally the 2 repositories are linked. an example: I create in Foundation [USER1], [GROUP1] and the association [USER1]…
NikoG
  • 17
  • 6
1
vote
1 answer

adding a meta user to a meta group in sas

I've around 600 meta users in SAS EGRC 6.1 in the platform in SAS 9.4. I want to add those users to a meta-group. for this, I'm using code below libname current '/tmp/temp1'; /* for the current metadata */ libname addgrps '/tmp/temp2'; /*…
Azeem112
  • 337
  • 1
  • 8
  • 23
1
vote
1 answer

Programmatically create a new Person having an Internal Login

I am trying to programmatically create Users with Internal Accounts as part of a testing system. The following code can not create an InternalLogin because there is not password hash set at object creation time. Can a person + internal account be…
Richard
  • 25,390
  • 3
  • 25
  • 38
1
vote
1 answer

SAS - Stored process is greyed out

I am very new to using the SAS Enterprise Guide but have been using older versions of SAS for a while. I also work a little in Javascript. Until today I was not aware these can be combined. I am trying to follow this tutorial. Interactive Charts and…
Catnipper
  • 53
  • 5
1
vote
1 answer

SAS EG: Prompts with Dynamic List on Metaserver

I'm trying to develop a SAS Prompt that has a drop down with values pulled from a field on a table I'm storing in the Work library. When I click "Browse" in the "Data Source" area, I'm confined to my SAS Folders. I'm on a metadata server and don't…
A.Luis
  • 11
  • 2
1
vote
1 answer

Adjust Metadata URI to Exclude WorkTable Metadata Type

I've built the code below for getting a list of SAS registered tables from metadata. It works fine but takes a long time to run due to the large volume of WorkTables (a subtype of PhysicalTable): data work.tables (keep=uri name); length uri name…
Allan Bowe
  • 12,306
  • 19
  • 75
  • 124
1
vote
2 answers

Autocall macro %mdsecds() generates syntax error

As per documentation, the mdsecds macro generates a series of datasets showing the permissions levels applied for each metadata object. We load this data into a database, to allow drill down (via a web app) to uncover fine grained permissions for…
Allan Bowe
  • 12,306
  • 19
  • 75
  • 124
1
vote
0 answers

how to access low level metadata from java api

I have tried to extract metadata for visual exploration objects using com.sas.metadata.remote.MdOMIUtil#getMetadataObjectsSubset method, but all I get is high level information like its name, fqid and the list of imported data sources. Is there…
Prasanna Raghu
  • 2,593
  • 3
  • 22
  • 25
1
vote
0 answers

How to change properties for a SAS user that is created as read-only?

I have created a user in SAS Management Console that can not modify his roles or accesses because his account is created as read-only and I don't know why. I have created other users in the same way and can modify them without any problem. What can…
Florentina
  • 85
  • 1
  • 1
  • 10
1
vote
2 answers

Generic way to get SAS Table metadata URI

I'm building a utility that leverages the SAS metadata ID (or URI) of a table object. The following code works fine for getting the ID when the library uses the BASE engine: %let mylib=SOMELIB; data output (keep=uri dataname); length uri $100…
Allan Bowe
  • 12,306
  • 19
  • 75
  • 124
1
vote
3 answers

Deploying/Re-Deploying SAS job in DIS via Script

Is there a possibility to deploy or redeploy a SAS job (Data Integration Studio) via a shell script ? Also is there a way to create its SPK file via script ?
Lastwish
  • 317
  • 10
  • 21
1
vote
1 answer

SAS Options metaserver

When I'm trying to connect to my prod metadata server in SAS with the options metaserver when connected to the testserver it doesn't find all libraries and tables. I am an unrestricted user and uses the code below. It works fine when I'm logged on…
user3270069
  • 31
  • 1
  • 4
1
vote
1 answer

Are SAS folders logical folders or physical folders

When I open up the SAS data integration studio, I see a 'Folders' tab which has a folder structure. Now, when i right click and see 'Properties' for a folder, I see something called a 'Location'. This location is not mapping to a physical folder…
Victor
  • 16,609
  • 71
  • 229
  • 409
1
vote
1 answer

Credentials for a sas metadata library-User ID

I have a situation here where I need the User ID of the SAS Metadata Libraries. I do not want to list out the users who access the Metadata. So, Fetch user id from SAS metadata server is not the solution for my query. Please help
Sakthi
  • 45
  • 6
1
2
3