SAS Users
Providing technical tips and support information, written for and by SAS users.![Why learn SQL?](https://blogs.sas.com/content/sgf/files/2022/07/9781955977890-702x336.jpg)
SQL (Structured Query Language) is the most widely used programming language for relational databases worldwide. No other programming language produces more hits for a web search than SQL and interest is growing rapidly. In June 2010, Google showed 135 million hits versus 586 million hits in June 2020. SQL is
![Splitting a data table into multiple sheets of an Excel workbook](https://blogs.sas.com/content/sgf/files/2022/07/fish-address-book-tabs-600x336.png)
Leonid Batkhan shows how to split a data table into multiple Excel spreadsheets in a single workbook.
![Getting Started with Python Integration to SAS® Viya® - Part 7 - Filtering CAS Tables](https://blogs.sas.com/content/sgf/files/2020/06/SAS-Viya-CAS-702x336.jpg)
Welcome to the seventh installment in my series Getting Started with Python Integration to SAS Viya. In previous posts, I discussed how to connect to the CAS server, how to execute CAS actions, and how to work with the results. Now it's time to learn how to filter CAS tables. Load and explore data
![Automating Excel workbooks creation using SAS](https://blogs.sas.com/content/sgf/files/2022/06/excel-logo-640x336.png)
Leonid Batkhan shows you how to automate and improve a sometimes onerous hands-on process of creating Excel workbooks.
![Beggars can’t be choosers…Unless they’re using SAS Viya](https://blogs.sas.com/content/sgf/files/2022/06/Picture1.png)
Have you ever heard the phrase “beggars can’t be choosers”? Basically, it means that if you ask for something, be grateful for what you get, especially if you don’t have the means to acquire it yourself. This phrase can be widely applicable to most areas of our lives, but when
![A comparison of the ODS destinations for writing to Microsoft Word](https://blogs.sas.com/content/sgf/files/2022/02/ProblemSolvers-400x336.jpg)
There are several alternatives to writing to a Microsoft Word file when you use the SAS® Output Delivery System (ODS). The RTF, TAGSETS.RTF and TAGSETS.RTF_SAMPLE destinations create an RTF formatted file. The WORD destination, which is still considered preproduction, creates a DOCX formatted file. The destinations provide many of the same functions, although some features are unique to each one. The destination that you choose might vary depending on your desired final output.