SAS Programming

DATA Step, Macro, Functions and more
BookmarkSubscribeRSS Feed
D_Z_
Obsidian | Level 7

Greetings All!

I need some advice from the community because i am diving into an area that i have very little knowledge in regards to SAS.

I am told that there is a way to build scripts via %CMS or X that can login to my Avaya CMS Supervisor and pull a report directly as a dataset into the SAS system.

I have looked all over and found a couple of references but nothing that i would consider concrete or informative enough to give me a starting point.

The reason that i am looking to do this is that because of contractual reasons with Avaya, we are not able to link directly to their database, however, if i was able to build a program that logged into the CMS system and pulled the data i wanted without connecting to the database, technically, i would not be violating their TOS.

From what i have read so far, there is apparently ways to use the native language for Avaya CMS scirpting through SAS.  If anyone has any idea on how to do this... i would be totally appreciative if you can help me get started.

I currently am working out of Enterprise Guide 5.1 if that helps.

Thanks,

DC

2 REPLIES 2
FriedEgg
SAS Employee

Cannot speak to the TOS, but it does seem that Avaya provides an ODBC driver to use for collecting data from the CMS system:

https://downloads.avaya.com/elmodocs2/contact_center/r3v11/780701_1/780701_1.pdf

Tom
Super User Tom
Super User

I don't think that Avaya CMS has anything to do with the CMS operating system from IBM.  Looks like Avaya CMS is a Call Management System.

sas-innovate-white.png

Our biggest data and AI event of the year.

Don’t miss the livestream kicking off May 7. It’s free. It’s easy. And it’s the best seat in the house.

Join us virtually with our complimentary SAS Innovate Digital Pass. Watch live or on-demand in multiple languages, with translations available to help you get the most out of every session.

 

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
  • 2 replies
  • 2619 views
  • 0 likes
  • 3 in conversation