Good morning, I'm looking for a way to access Workday data directly from SAS. Any help would be appreciated.
Thanks,
Jeff
Since there really isn't any truly standard "workday" definition you will need to provide what your definition of "workday" is for your project.
Pieces likely to be involved: day of week can be retrieved from a SAS date value, specific holidays can also be determined from SAS date values though non-US holidays require additional work to set up.
I believe that Workday has APIs you can use. Using PROC HTTP you can call those APIs, similar to the way you might use cURL.
It looks like the Workday API documentation is restricted to verified customers/developers, so you may need to create a community account at
https://community.workday.com and be approved for access. Since I cannot see the doc, I can't provide better guidance/examples.
I suspect one of the biggest initial challenges will be authentication. Most enterprise-style APIs will use OAuth2 or similar mechanism to get an access token and refresh that token for new access every time you use it. We have several examples of that type of interaction (ex: How to use SAS to access Microsoft 365 ).
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.