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

sas update column order in metadata

We are using proc metadata (open metadata interface) to update some metadata from XML. Using updatemetadata method, how can we achieve the following: add a new column to a specific location in the Columns association of a given table with the use…
Diepie
  • 772
  • 1
  • 8
  • 15
1
vote
1 answer

Fetch user id from SAS metadata server

I am working in a configuration that uses the IOM to connect to the metadata server - hence there are no automatic macro variables in my environment to determine the user id (we are using a pooled workspace server with a generic host account). Is…
Allan Bowe
  • 12,306
  • 19
  • 75
  • 124
0
votes
0 answers

batch ExportPackage SAS

Batch export sas crash a few time Good day everyone, I am having issues with using ExportPackage. During the export of a large folder with metadata, the script crashes after a minute and a half. This occurs specifically with a large volume of…
0
votes
2 answers

metadata_newobj function in SAS 9.2 has a bug?

I have a SAS application that I am testing with the newly released SAS 9.2. I have a call to the metadat_newobj function to create a new Library object in the SAS metadata repository: rc = metadata_newobj( "SASLibrary", URI, Name ); In 9.1.3, when…
Adnan
  • 2,949
  • 4
  • 29
  • 45
0
votes
2 answers

Create SASLibrary Metadata with Extended Attributes Programmatically

Due to a requirement in creating multiple SAS libraries from time to time in the MC, I am trying to figure out how to do this programmatically. These libraries are pointing to external databases. So far, using the available examples I was able to…
Sam
  • 850
  • 1
  • 10
  • 20
0
votes
3 answers

Get the list of libraries assigned to an application server in SAS Metadata

Is it possible to get the list of libraries assigned (pre & non-pre assigned) to an application server in SAS Metadata? I can use dictionary.libnames but it lists only pre-assigned libraries.
athresh
  • 553
  • 6
  • 11
  • 24
0
votes
2 answers

SAS Metadata Objects Details - SASLibraries, PhysicalTables, Jobs

I've used this code to fetch the list of objects for all SAS Libraries, Physical Tables and Jobs. https://github.com/sasjs/core/blob/master/meta/mm_getobjects.sas I now need to fetch these objects details, Like for Libraries - I need their libname…
Rhea
  • 283
  • 1
  • 5
  • 17
0
votes
1 answer

Get timeoutseconds value for a Stored Process server

As per documentation: "timeoutseconds = seconds" The TIMEOUTSECONDS parameter specifies the time interval that an OLAP server or a stored process server waits before it stops a client process and cleans up the server run-time …
Allan Bowe
  • 12,306
  • 19
  • 75
  • 124
0
votes
0 answers

SAS: how to change SAS text miner background color?

Can I change the background color of SAS text miner window. Below is snapshot of such window. How Can I change the gray to white or other color? Thanks.
Dylan
  • 1,183
  • 4
  • 13
  • 26
0
votes
0 answers

How to view tables in sas 9.4 in sasoprsk library

I have a sas server of EGRC 6.1 module and I can't see the tables in sasoprsk library after running autoexe in sas 9.4 After runing autoexe it start showing libraries in explorer tab of sas 9.5 but it didn't show the tables of sasoprsk…
Azeem112
  • 337
  • 1
  • 8
  • 23
0
votes
1 answer

SAS Assign Role or Group to User

I have a user account, but i need a script for assign a role or group to my user, is this possible from Enterprise Guide? PDT: The role and the group was created previously.
0
votes
1 answer

assigning a metadata user via the sassrv account

I have built a test harness on the STP server, that spawns unique sessions for each test run. The problem I have now is that one of my tests requires the use of a metadata account (and my spawned sessions are running under the sassrv system…
Allan Bowe
  • 12,306
  • 19
  • 75
  • 124
0
votes
2 answers

How to generate a list of all metadata objects deployed in SAS Platform?

I have a production environment server using SAS Platform. Is there a way to generate a report of a list of all metadata objects deployed in this production environment? More accurately, is there an easy point-and-click way using one of the SAS…
barney
  • 141
  • 1
  • 2
  • 6
0
votes
2 answers

Retrieving tables located on metadata server with SAS

I want to list all tables on metadata server. I've tried with the following data step but it only pics one table per library and I can't figure out why. This is the code I've been using: options metaserver="xxxx" metaport=8561 …
user3270069
  • 31
  • 1
  • 4
1 2
3