Posts Tagged ‘ excel ’

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

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

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

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

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

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

The top gotchas when moving to 64-bit SAS for Windows

May 1, 2012
By

Many SAS customers are quickly adopting 64-bit versions of Microsoft Windows, and they are pleased-as-punch when they find a 64-bit version of SAS to run on it. They waste no time in deploying the new version, only to find that a few things don't work quite the same as they
Read more »

Tags: , ,
Posted in SAS | Comments Off

Face Off: Review OpenCDISC XML files

February 11, 2012
By
Face Off: Review OpenCDISC XML files

OpenCDISC, the first open source CDISC validator, is already in the toolbox of FDA reviewers (CDER/CBER, see CDISC Standards in the Regulatory Submission Process, 26 January 2012, P.33). The key features in OpenCDISC is a dichotomy of validation rules (XML based) and application logic. Currently OpenCDISC Validator (Version 1.2.1) officially supports the four following...
Read more »

Tags: , , , , , , ,
Posted in SAS | Comments Off

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: [email protected]

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.