Posts Tagged ‘ excel ’

SAS graphs and Excel data, from Unix!

August 1, 2018
By

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...
Read more »

Tags: , , , , ,
Posted in SAS | Comments Off on SAS graphs and Excel data, from Unix!

What’s the most popular language in each US state?

July 30, 2018
By

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 Read more »

Tags: , , , , , , ,
Posted in SAS | Comments Off on What’s the most popular language in each US state?

Import Excel data, transpose, and plot it!

July 20, 2018
By

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...
Read more »

Tags: , , , , ,
Posted in SAS | Comments Off on Import Excel data, transpose, and plot it!

How to use SAS to read a range of cells from Excel

June 21, 2018
By
How to use SAS to read a range of cells from Excel

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 Read more »

Tags: ,
Posted in SAS | Comments Off on How to use SAS to read a range of cells from Excel

Send your SAS graphs to Excel, directly to Excel …

November 15, 2016
By

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 Read more »

Tags: , , ,
Posted in SAS | Comments Off on Send your SAS graphs to Excel, directly to Excel …

Copy data and column names from SAS Enterprise Guide

August 10, 2015
By

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 Read more »

Tags: , ,
Posted in SAS | Comments Off on Copy data and column names from SAS Enterprise Guide

Using LIBNAME XLSX to read and write Excel files

May 20, 2015
By

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 Read more »

Tags: , , , , ,
Posted in SAS | Comments Off on Using LIBNAME XLSX to read and write Excel files

Why your DDE programs don’t work anymore

October 14, 2014
By

Hello, 1992 called. They want their DDE Excel automation back. Perhaps the title of this article is too pessimistic. Of course your SAS programs that use DDE (dynamic data exchange) can still work perfectly, as long as you situate your SAS software and its DDE "partner" (usually Microsoft Excel) to

The post Read more »

Tags: , , , , ,
Posted in SAS | Comments Off on Why your DDE programs don’t work anymore

Welcome!

SAS-X.com offers news and tutorials about the various SAS® software packages, contributed by bloggers. You are welcome to subscribe to e-mail updates, or add your SAS-blog to the site.

Sponsors







Dear readers, proc-x is looking for sponsors who would be willing to support the site in exchange for banner ads in the right sidebar of the site. If you are interested, please e-mail me at: tal.galili@gmail.com
SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration.