The addition of the PYTHON procedure and Python editor in SAS Viya enables users to execute Python code in SAS Studio. This new capability in SAS Viya adds another tool to SAS’s existing collection. With this addition I thought, how can I utilize this new found power? In this example, […]
Creating a Microsoft Excel report using SAS, Python and SQL! was published on SAS Users.
I started my computer career as a Unix system administrator, and when I began using SAS almost 30 years ago it was only natural that I used it on Unix computers (they were the most powerful/capable computers I had access to at the time). I’ve picked up…
I can recognize several languages when I hear people speaking them (mostly because I lived in the Alexander International Dorm at NC State University). Therefore when I found a map of the most common languages spoken in each US state, it caught my attention, and I decided to try creating my […]
The post What’s the most popular language in each US state? appeared first on SAS Learning Post.
Of course you know how to create graphs … But do you often find that preparing the data to plot is often the hardest part? Well then, this blog post is for you! I’ll be demonstrating how to import Excel data into SAS, transpose the data, use what wer…
I’ve said it before: spreadsheets are not databases. However, many of us use spreadsheets as if they were databases, and then we struggle when the spreadsheet layout does not support database-style rigor of predictable rows, columns, and variable types — the basic elements we need for analytics and reporting. If […]
The post How to use SAS to read a range of cells from Excel appeared first on The SAS Dummy.
Are you the lone-wolf SAS programmer in your company – managing the data, performing the analyses, and graphing the output for everyone else? And what’s the only format they all know how to work with, and wish they had your output in? Let’s face it … that’s probably an Excel […]
The post Send your SAS graphs to Excel, directly to Excel … appeared first on SAS Learning Post.
While I’ve often written about how to get your SAS data to Microsoft Excel in some automated way, I haven’t really addressed what’s probably the most frequently used method: copy and paste. SAS Enterprise Guide 7.1 added a nifty little feature that makes copy-and-paste even more useful. The new “Copy […]
The post Copy data and column names from SAS Enterprise Guide appeared first on The SAS Dummy.
When you weren’t watching, SAS did it again. We smuggled Yet Another Excel Engine into a SAS release. SAS 9.2 Maintenance 2 added the XLSX engine, which allows you to read and write Microsoft Excel files as if they were data sets in a library. The big advantage of using […]
The post Using LIBNAME XLSX to read and write Excel files appeared first on The SAS Dummy.