About joeFurbee

joeFurbee · ‎02-16-2023

We 'stepped out' in the latest rendition of the SAS Bowl where we learned about custom steps in SAS Studio. We covered how easy it is to create, implement and share custom steps. We even have a sassoftware GitHub repository with dozens of examples! Read on for the game replay and some highlights. Game replay If you want to view (or re-view) the game, catch the action in the video below. Game Highlights You should only watch the movie "Pride and Prejudice and Zombies" if you have strong drinks and/or catnip available. Kangaroos can't walk backwards We confirmed Puerto Rico is a U.S. territory, which means it is neither a state nor an independent country. Certainly a gray area. According to @DavidHD, the Send Teams Message step is the best custom step on sassoftware GitHub; #notBiased he states. Congratulations to the winners 1st place - @DavidHD 2nd place - @MichelleHomes 3rd place - @fja Your swag is on its way. Next up On Wednesday, March 8, at 10 AM ET, we'll host SAS Bowl XXIX, The SAS Hackathon. The brightest minds from around the world come together to use SAS Analytics, AI and open source on Microsoft Azure to collaborate in the #SAShackathon. Registration is now open (through February 28) and the Hack runs from March 15 through April 15. Be sure to check the SAS Communities Events Calendar for all the details.

joeFurbee · ‎02-15-2023

The brightest minds from around the world come together to use SAS Analytics, AI and open source on Microsoft Azure to collaborate in the #SAShackathon. Registration is now open (through February 28) and the Hack runs from March 15 through April 15. The SAS Hackathon is such a great event, we're featuring it in the March edition of the SAS Bowl. Game Details The SAS Support Community trivia event, SAS Bowl XXIX, The SAS Hackathon is scheduled for Wednesday, March 8, at 10 AM ET. Register for the event and receive an invite to a Microsoft Teams meeting and a calendar event. On game day, join the Teams meeting and access the game here. More on the SAS Hackathon Hackers bring their idea and data and SAS provides a subject matter expert as a mentor, free access to our suite of industry-leading software, and a month to accelerate the vision. Teams are divided into tracks based on the nature of their project. Participants also receive access to enablement resources, virtual learning labs, training courses and more. The SAS Hackathon is so cool, @thiago rapped about it. You can find more information on the Hackathon on the SAS Hacker's Hub in the SAS Support Community. We even have a matchmaking section where we pair individuals looking for a team with teams seeking specific skill sets. Below are other SAS Hackathon-related resources we'll use to create questions for the game. SAS Hackathon Kickoff video - hear the details about registering and participating in the SAS Hackathon; hosted by @MarinelaProfi Why hack? 10 reasons why the SAS Hackathon is more than a competition - SAS Users blog post by the SAS Hackathon King, @Einar_H Past SAS Hackathon participant use cases - Team profile pages from past SAS Hackathon participants outlining their use cases SAS Hackathon Frequently Asked Questions (FAQ) - get all your questions answered on this SAS Hacker's Hub FAQ post by @Christine4 Accelerate your idea and innovation through the SAS Hackathon 2023 - SAS Hackathon 2023 fact sheet from @Peter7 SAS Bowl and event details For those who may be new to the SAS Bowl, you can find game history and specifics in this Community memo. There you'll also find links to previous events, which include recordings. Register for the event and receive an invite with game details and a Teams meeting link. On game day, Join the TEAMS meeting to play, and show off your SAS and worldly knowledge while competing for bragging rights and SAS Community game gear.

joeFurbee · ‎01-31-2023

Hi @AreSivertsen, @DavidHD beat me to the answer. I'll add a link to the SAS Logon API doc for reference. You will see all of the client end points defined.

joeFurbee · ‎01-26-2023

We kicked off the new year with a riveting SAS Bowl event as it came down to the last question. We even had our first ever tie for third place. Participants entertained questions on CAS Actions and we learned a lot about how to invoke them in SAS Viya to do all the 'statisticy' (new word coined by host @joeFurbee) things users need. Read on for the game replay and some highlights. Game replay If you want to view (or re-view) the game, catch the action in the video below. Game Highlights We discovered Renaldo is more popular on Twitter (535M followers) than the host (336 followers). We learned that dragon flies are the only insect with the ability to fly forwards, backwards, and sideways. @TomKari worked through his technical issues and was able to access the Teams call; nice to see you Tom! We had one user who answered almost every question in the chat; doh!; needless to say they did not have a high score. Congratulations to the winners 1st place - @Bruehl 2nd place - @ronan 3rd place - @JulianVogel 3rd place - Annie Kaiser Your swag is on its way. Next up On Wednesday, February 15, at 10 AM ET, we'll host SAS Bowl XXVIII, SAS Studio Custom Steps. Easy to create, integrate, and use, custom steps enable you to create a user interface in SAS Studio on SAS Viya for users to complete a specific task. Custom steps are saved to SAS Content, so they can be shared with others at your site. Be sure to check the SAS Communities Events Calendar for all the details.

joeFurbee · ‎01-26-2023

Hi @Resa, Thanks for your inquiry. You have several options here. Credit to @Mike_Drutar for his fact checking my response. First, no, I don't believe there is a mechanism to select fields returned in the response. Most APIs I’ve worked with function similarly. What you can do is parse the response and we have LOTS of options there. As for the default number of 20 items returned in the response, you can use the limit=x parameter in your call to return more data. If you are making the API call from SAS using proc http, you can store the response in a file and use the JSON libname engine to convert the response as a nicely formatted dataset - and then use actual SQL to keep or drop any variables. Pretty neat and easy, huh? If you’re using a different client, say Postman, you can put the response contents in a json file, load it into SAS and again parse using the json libname. An example is: filename response "C:\temp.json" libname response json; In SAS Viya, you can upload the json file to a Viya content folder (like "/Public" or "/My Folder"), which lets you reference a file located in a viya content folder. Then use the FILENAME : FILESRVC Access Method. For example: filename myfldr2 filesrvc folderpath='/Shared Data/Sales' filename='sales.json'; Here’s a more comprehensive example from Mike: Download the response from http://viyaserver.com/reports/reports (which is a listing of 20 reports) as reports.json Local SAS (using the local filename statment): save it to C:\temp\reports.json: SAS Code: filename rpt "C:\temp\reports.json"; libname rpt json; proc print data=rpt.items; var name createdBy creationTimeStamp modifiedBy; run; The SAS Viya platform (using the filesrvc filename statement): Upload reports.json to a folder (example: /Public): SAS Code: filename rpt filesrvc folderpath='/Public/' filename='reports.json'; libname rpt json; proc print data=rpt.items; var name createdBy creationTimeStamp modifiedBy; run; Please let me know if you have further questions or need more information. --Joe

joeFurbee · ‎01-18-2023

Hi @JohnMeistrell, Thanks for your inquiry. It's great to hear from people passionate about their work and experience. Your post is quite timely. We are preparing for the SAS Hackathon (March 15- April 15). Some teams come with all their members and data; however, we also have a matchmaking component, where you can express interest and list your skills and preferences. Follow this link to the Hacker's Hub and there are instructions on the process. Thanks, Joe

joeFurbee · ‎01-12-2023

Hi @AllanBowe, Happy New Year! I've posed the question to a developer. He's in the AP region, so I probably won't hear anything until tomorrow. I'll post the response here, once I get something back. Thanks, Joe

joeFurbee · ‎01-10-2023

A custom step enables you to create a user interface in SAS Studio on SAS Viya for users to complete a specific task. Custom steps are saved to SAS Content, so they can be shared with others at your site. They are easy to create and very useful. We'll highlight SAS Studio custom steps in the February edition of the SAS Bowl. Game Details The SAS Support Community trivia event, SAS Bowl XXVIII, SAS Studio Custom Steps is scheduled for Wednesday, February 15, at 10 AM ET. Register for the event and receive an invite to a Microsoft Teams meeting and a calendar event. On game day, join the Teams meeting and access the game here. More on SAS Studio Custom Steps The SAS Studio Flow “Custom Step” framework was released in SAS Viya 2020.1.5. After the advent of SAS Studio Flows, Custom Steps are a big step forward in providing visual and flexible data manipulation/integration jobs with shared reusable components in the new SAS Viya. SAS Studio custom steps is a relatively new tool, but many resources are available documenting its use. Use the resources below to get familiar and brush up for the game. Create a Custom Step in SAS Studio on SAS Viya - Video tutorial on YouTube by @MKQueen Custom Steps in SAS Studio - SAS Communities article by @Wilbram-SAS My First SAS Studio Flow Custom Step - SAS Communities article by @NicolasRobert SAS Studio Custom Steps - GitHub repository with many examples and sample code SAS Documentation on Custom Steps in SAS Studio SAS Bowl and event details For those who may be new to the SAS Bowl, you can find game history and specifics in this Community memo. There you'll also find links to previous events, which include recordings. Register for the event and receive an invite with game details and a Teams meeting link. On game day, Join the TEAMS meeting to play, and show off your SAS and worldly knowledge while competing for bragging rights and SAS Community game gear.

joeFurbee · ‎01-04-2023

Hi @sasuser_01, This thread has gone a while with no activity. Were you able to attempt the solutions provided from other community members? Are you able to provide the requested data? Thanks, Joe

joeFurbee · ‎12-22-2022

Hi @daRocha, The developer took another look at this and while the error seems to be suppressed in his testing the file is not processed. IOW, we still have an issue. I'll follow the progress of the fix and will update you when it's fixed and in which version of SAS 9. Thanks, Joe

joeFurbee · ‎12-22-2022

Hi @daRocha, Your SAS version should have the patch. We may have to open a tech support ticket to investigate. Before we do that, the developer I spoke with asked the following: Can he provide the debug logs for the run? Setting logger App.tk.HTTPC to debug would be good to see what is going on. Can you provide the logs for us here?

joeFurbee · ‎12-20-2022

Hi @daRocha, I checked with SAS R&D and found out: The fix is in 9.4m7 and beyond and in Viya. Thanks, Joe

joeFurbee · ‎12-17-2022

SAS Viya uses the Cloud Analytics Service (CAS) to perform tasks. The smallest unit of work for the CAS server is a CAS action. Think of CAS actions as powerful functions or methods created specifically to process data in the CAS server. We'll cover more CAS action details when we feature them in January's edition of the SAS Bowl. Game Details The SAS Support Community trivia event, SAS Bowl XXVII, CAS Actions is scheduled for Wednesday, January 18, at 10 AM ET. Register for the event and receive an invite to a Microsoft Teams meeting and a calendar event. On game day, join the Teams meeting and access the game here. More on CAS Actions CAS actions can load data, transform data, compute statistics, perform analytics and create output. Each action is configured by specifying a set of input parameters. Running a CAS action in the CAS server processes the action's parameters and the data and creates an action result. Actions are organized into functional groups call Action Sets. Run CAS Actions from anywhere! You can run CAS actions directly from SAS, using an open source language of your choice, or even through REST API calls. This makes CAS actions quite effective, versatile, and mobile. CAS actions are well documented. Below is a small sample of resources to get you started. We'll pull from these links to create questions for the game. CAS Action! - a series on fundamentals - SAS Users blog post series by @Panagiotis Can I Call CAS Actions Using REST APIs? - Ask the Expert webinar from @joeFurbee CAS Actions for SAS® Visual Analytics Report Developers - SASGF paper by @Mike_Drutar SAS Viya Actions and Action Sets by Name and Product - doc page for Action Sets and Actions SAS Tutorial | Introduction to CAS and Coding in CASL in SAS Viya - YouTube tutorial by @zhongxiuliu SAS Bowl and event details For those who may be new to the SAS Bowl, you can find game history and specifics in this Community memo. There you'll also find links to previous events, which include recordings. Register for the event and receive an invite with game details and a Teams meeting link. On game day, Join the TEAMS meeting to play, and show off your SAS and worldly knowledge while competing for bragging rights and SAS Community game gear.

joeFurbee · ‎12-13-2022

@gwootton covers most everything you need. A couple of follow up notes. The easiest solution here is to create a new client id and generate the access token following the steps in the blog post. In order to view current clients, you do have to hit the clients API endpoint. Note that you need an access token with admin privileges to access the endpoint. That is, include these scopes when registering the client: "scope": ["openid","*","clients.admin"]. I created a Python Notebook that registers a new client id and generates an access token. You only need to provide four pieces of info: consul token, SAS server URL, client id and client secret.

joeFurbee · ‎11-30-2022

Hi @Atabarut , Thanks for visiting the SAS Community, reading the article, and posting your question. I'd recommend posting this question in a thread on the Visual Analytics board. Please make sure to reference this article. Thanks, Joe

Online Status	Online
Date Last Visited	2 hours ago