SAS Programming

DATA Step, Macro, Functions and more
BookmarkSubscribeRSS Feed
jkotek
Calcite | Level 5

Good morning, I'm looking for a way to access Workday data directly from SAS. Any help would be appreciated.

Thanks,

Jeff

3 REPLIES 3
ballardw
Super User

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.

ChrisHemedinger
Community Manager

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

Register for SAS Innovate 2025!! The premier event for SAS users, May 6-9 in Orlando FL. Sign up now for the best deals!
Reeza
Super User
Workday data lives in the cloud and is relational IIRC. We're having our IT team build some data layers for us from the data to then surface on Azure.

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1059 views
  • 0 likes
  • 4 in conversation