SAS Support Communities

Resa · ‎06-14-2024

Thank you @ronald297 for your reply. Currently my approach is as you suggest, albeit in SAS code. I used a JSON libname statement and filter out the information that I need. Although in some cases, for example when you want to retrieve groups and their members, I now have to make two API calls. The first to get the required information about the group, the second to get the requirec information about the members in that group. Being able to do this within one API call would be nice. Maybe a nice feature to be considered for a future release of the REST API ... selectedFields? 😉

Resa · ‎05-03-2024

I have recently started to make some reports about the reports within our Viya 4 environment using the documentation I could find and have basically succeeded to retrieve the information we need. However, what I have not been able to find is whether there is a way to limit the items returned when doing an API call. For example within the PI Web API it is possible to use the "selectedFields" parameter. I have not been able to find a similar parameter within the documentation for the SAS Viya REST API, therefor my question: Is such a parameter available? For example to use an URL like: &BASE_URI/folders/folders/&uri/members?start=0&limit=10&selectedFields=items.name,items.id Which would give me only the name and id field from the items "table"

Resa · ‎03-12-2024

Coincidentally we encountered the same issue as the OP on the same day, so we as well have tried the proposed solution. The only thing that we have noticed that it took us up to three tries to delete all objects. In other words, during the first try we got an rc of -3 on some of the objects and on most of the objects an rc of 0. During the second try we had an rc of 0 on the remaining objects but one. The third try removed the final one.

Resa · ‎03-22-2023

I have recently attended the "Online Meetup: What's New in SAS 9 Maintenance 8?" as hosted by the SAS User Group UK & Ireland. Is the content similar/the same as presented during this presentation? Just asking to determine the necessity of registering.

Resa · ‎03-20-2023

@Patrick thanks for the suggestion. The solution as proposed is indeed a workable solution and does the job. Personally I am not a big fan of either pre- or postcode since it is easily overlooked but for now this seems the only way. My personal opinion still is that the transformation should provide the possiblity to opt for proxy settings. But for now this works.

Resa · ‎03-17-2023

We are trying to make use of the REST Transformation (DIS v4.904) in order to retrieve data using PROC HTTP. However in our environment we have to specify a proxy (as also shown in this example for PROC HTTP). As far as I can determine the transformation does not provide the possibility for setting either the proxyhost or proxyport. Am I overlooking something? If not, did anyone make a "User Transformation" based on the REST Transformation including the possibility to specify a proxy?

Resa · ‎02-09-2023

@Quentin SAS/Session is mentioned in the list of Retired Products and Features on the What's new page for SAS 9.4 M8 (https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/whatsdiff/upgradeswhatsnew94.htm)

Resa · ‎01-26-2023

Hi @joeFurbee, Thanks for the quick response. Basically answered my question already with your statement: no, I don't believe there is a mechanism to select fields returned in the response. I was hoping that (as with the PI REST API) there was a possibility to select the information that you would like to have in the output. With regard to the solutions you've mentioned. I was and am aware of the various ways to obtain and save the data, that was not my major issue. 😉 Maybe something to consider to include in the API, the possibility to select columns? 🤔

Resa · ‎01-26-2023

We are in the process of trying to retrieve information from the SAS Viya environment by using the REST API. In order to make my question clear I will use in this example that we are trying to retrieve the name, description, type, memberCount and parentFolderUri from all folders. In the current situation when we make the initial call, the following information is returned: { "version": 2, "accept": "application/vnd.sas.content.folder", "count": 943, "start": 0, "limit": 20, "name": "folders", "items": [{ "creationTimeStamp": "2022-11-07T15:23:51.213681Z", "createdBy": "who.ever@somecompany.com", "modifiedTimeStamp": "2022-11-07T15:23:51.213684Z", "modifiedBy": "who.ever@somecompany.com", "version": 1, "id": "0016a0ee-2461-46f8-a794-0267ee63f65f", "name": "SomeFolder", "parentFolderUri": "/folders/folders/b12eee80-32a4-42f0-a905-272742be7dae", "description": "Some Folder Description", "type": "folder", "memberCount": 6, "links": [{ "method": "GET", "rel": "self", "href": "/folders/folders/0016a0ee-2461-46f8-a794-0267ee63f65f", "uri": "/folders/folders/0016a0ee-2461-46f8-a794-0267ee63f65f", "type": "application/vnd.sas.content.folder" Basically all information for the first 20 folders is returned while I only want limited information returned. Although sufficient information is provided that I can achieve what I want I would like is to do this more directly. In the Osisoft PI REST API there is the possibility to select the fields that are being returned. Basically (to keep it in SQL terms) it provides the possibility to not only do: select * from ... but to change this into: select column1, column5 from ... Basically what I am looking for is to start out with (NOTE: the selectedFields is how it is done for PI): https://example.com/folders/folders?selectedFields=count This would return me only the value: 943 After this I could loop using the "column filter" plus the start and limit parameters to retrieve the required information for each folder using: https://example.com/start=x&limit=20&selectedFields=Items.name;Items.description;Items.type;Items.memberCount;Items.parentFolderUri Giving me hereby only the specific information I would like to have. Now to get to my specific question: Is there a SAS Viya REST API equivalent for the "selectedFields" as used in the example?

Resa · ‎09-13-2022

Just wondering ... is the delivery of the swag limited to US residents only? #dta SAS Explore registration

Resa · ‎02-09-2021

@japsas100 , Did @gwootton replied to your question sufficiently? Just want to make sure you have been able to retrieve the information that you were looking for.

Resa · ‎02-08-2021

There are several ways to obtain this information, but I think a good starting point is the SAS blog post: "SAS administrators tip: Keeping track of SAS users". NOTE: Be aware that the outcome is dependant on the access that you have to metadata. In other words if the account that you are using is not allowed to "see" all users that will be reflected in the outcome.

Resa · ‎02-01-2021

Just to make sure: Did you tick the box to always open this app when opening .sas files?

Resa · ‎02-01-2021

Sorry to hear so. For met it worked for both .sas7bdat files and for .sas files (see attachment, which - sorry - is in Dutch). Have you tried looking for the SEGuide.exe file (in case SEG does not appear "automatically")?

Resa · ‎02-01-2021

I also have both SEG v7 and v8 installed. IIRC I have set the preference by looking up a SAS dataset (.sas7bdat file) in Windows Explorer. I then did a right click and selected "Open with ..." and looked for SEG v8. Next ticked the box to "Always open .sas7bdat files with this application" Hope this helps.

Online Status	Offline
Date Last Visited	a month ago

SAS Support Communities

Follow Us

What is...