SAS to SQL conversion

Ammonite | Level 13

Re: SAS to SQL conversion

Posted 11-29-2017 12:00 PM (480 views) | In reply to RM6

Please be aware of the following:

- Microstrategy is a Reporting Platform that can connect to different underlying data sources (RDBMS, Hadoop, NoSQL Databaes, ...etc)

- "<function()> OVER ()" are SQL Analytical functions syntax supported by selective Databases and not necessary at the same level of support!

Having said, jrajesh61 will need to investigate the ability of his SQL based data source to support these analytical functions!

Just my 2 cents,

Ahmed

April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Call for Content EXTENDED

Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.

Submit your proposal!

Discussion stats

15 replies
‎11-29-2017 04:38 AM
4767 views
2 likes
6 in conversation

Re: SAS to SQL conversion

Registration is open

Call for Content EXTENDED

SAS Training: Just a Click Away