Resa Tracker

Re: SAS Viya REST API: Is it possible to return only selected fields in an API call?

Resa — Fri, 14 Jun 2024 09:01:57 GMT

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? 😉

SAS Viya REST API: Is it possible to return only selected fields in an API call?

Resa — Fri, 03 May 2024 08:51:39 GMT

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"

Re: Problem deleting metadata objects

Resa — Tue, 12 Mar 2024 10:51:15 GMT

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.

Re: Ask the Expert webinar on upgrading to the latest version of SAS 9.4 M8

Resa — Wed, 22 Mar 2023 08:40:28 GMT

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.

Re: DI Studio REST Transformation with Proxy settings

Resa — Mon, 20 Mar 2023 10:16:23 GMT

@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.

DI Studio REST Transformation with Proxy settings

Resa — Fri, 17 Mar 2023 13:27:20 GMT

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?

Re: SAS 9.4 M8 is now available!!

Resa — Thu, 09 Feb 2023 16:43:37 GMT

@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)

Re: SAS Viya REST API: Select output fields

Resa — Thu, 26 Jan 2023 16:54:57 GMT

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? 🤔

SAS Viya REST API: Select output fields

Resa — Thu, 26 Jan 2023 10:40:59 GMT

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?

Re: Get Your SAS Explore Swag: Limited Quantity!

Resa — Tue, 13 Sep 2022 08:22:25 GMT

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

Re: Metadata Details via EG

Resa — Tue, 09 Feb 2021 17:00:05 GMT

@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.

Re: Metadata Details via EG

Resa — Mon, 08 Feb 2021 16:02:16 GMT

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.

Re: Set the preferred version of SEG to run when two versions are installed

Resa — Mon, 01 Feb 2021 15:25:53 GMT

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

Re: Set the preferred version of SEG to run when two versions are installed

Resa — Mon, 01 Feb 2021 15:18:33 GMT

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")?

Re: Set the preferred version of SEG to run when two versions are installed

Resa — Mon, 01 Feb 2021 14:50:49 GMT

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.

Re: SUGA webinar on October 8: ESM tool for SAS

Resa — Wed, 04 Sep 2019 15:39:14 GMT

Thank you @ShelleySessoms , registration worked fine now

Re: SUGA webinar on October 8: ESM tool for SAS

Resa — Wed, 04 Sep 2019 12:13:34 GMT

@ShelleySessoms when I try to follow the link to register I get the message "The message you are trying to access is not available"

Re: SAS_lsm, the next generation

Resa — Wed, 19 Jun 2019 17:58:42 GMT

My vote goes out to the non sas.servers based tier samples and like to suggest adding starting, stopping SPDS to the list.

Furthermore indeed adding the possibility to include cleanwork and backup is surely high on my wishlist.

Re: SAS Connect and "Conversation termination; status=1." error

Resa — Wed, 13 Mar 2019 21:14:23 GMT

We have been and occasionaly are facing a similar issue and I agree with @doug_sas that these issues are hard to debug.

We have had - and sorry, can't explain why - a reduction in occurrence by adding a "sleep" between the queries that we were sending to the remote host, like below:

<code part 1>

data _null_;
   call sleep (2,1);
run;

<code part 2>

data _null_;
   call sleep (2,1);
run;

<code part n>

Furthermore we have been monitoring the remote connections with the Linux lsof command on the connect spawner port and indeed noticed that occassionally the connection gets lost. Up until now without finding out the reason why.

Finally, in the remote sessions we are querying a database and we noticed that occassionally our remote session became unresponsive because the database was unresponsive.

All in all quite a lot of possible causes and baby steps to prevent it from occurring.

Good luck and hope you can fully prevent it from happening

Re: Upcoming SUGA Webinar on SAS Grid Manager: Tuesday, March 12

Resa — Wed, 13 Mar 2019 13:17:31 GMT

@doug_sas thanks for jumping in.

However, as @ShelleySessoms indicated, I think it is only fair that I give Eduardo time to respond my questions asked in the Q&A during his webinar.

Should they remain unanswered I will repeat them here.