Posts Tagged ‘ excel ’

Copy data and column names from SAS Enterprise Guide

August 10, 2015
By
Copy data and column names from SAS Enterprise Guide

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
Using LIBNAME XLSX to read and write Excel files

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
Why your DDE programs don’t work anymore

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

Don’t panic: maybe your XLSX file is already opened

September 24, 2014
By

As you can tell from my recent posts (see here and here), I've been working with SAS and Microsoft Excel files quite a bit. I'm really enjoying the ability to import an XLSX file in my 64-bit SAS for Windows without any additional setup. After one long afternoon of back-and-forth

The post Read more »

Tags: , , ,
Posted in SAS | Comments Off on Don’t panic: maybe your XLSX file is already opened

Using ODS EXCEL and PROC EXPORT to bundle Excel-based reports

September 21, 2014
By
Using ODS EXCEL and PROC EXPORT to bundle Excel-based reports

I recently wrote about my foray into the experimental world of ODS EXCEL. Using this new destination in SAS 9.4, I was able to create multisheet workbooks -- containing reports and graphs -- in the XLSX format. I outlined some of the benefits -- such as being part of Base

The post Read more »

Tags: , , , , ,
Posted in SAS | Comments Off on Using ODS EXCEL and PROC EXPORT to bundle Excel-based reports

Get Started with SAS Tagsets.ExcelXP

January 5, 2013
By
Get Started with SAS Tagsets.ExcelXP

Hate it or not (Yes I do), SAS programmers can’t just get rid of Microsoft Office Excel in their life. Now my turn (with Tagsets.ExcelXP, I can at least get rid of DDE)… 0. SAS Templates window A visual way to browse all ODS templates is to use windows command “ODSTEMPLATES” to invoke a...
Read more »

Tags: , , , , , ,
Posted in SAS | Comments Off on Get Started with SAS Tagsets.ExcelXP

Do you use SAS for analytics and Excel for graphs?

August 10, 2012
By

Do you use SAS for analytics and Microsoft Excel for graphs? Why not use SAS for your graphs too?!?  Then you could completely automate the entire process in one SAS program, with no manual steps! A lot of people use Excel to create their graphs be...
Read more »

Tags: , , ,
Posted in SAS | Comments Off on Do you use SAS for analytics and Excel for graphs?

Query the Windows registry within your SAS program

May 22, 2012
By

On the SAS-L mailing list, a participant posed this question (paraphrased): How can I tell which date format my Windows session is using: European format (with day first) versus USA format (with month first)? I'm reading in output from a Windows file listing, and need to know how to interpret
Read more »

Tags: , , , , ,
Posted in SAS | Comments Off on Query the Windows registry within your SAS program

Proc-x is looking for 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

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.

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.