Tag: excel

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 Why your DDE programs don’t work anymore appeared first on The SAS Dummy.

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

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 Don’t panic: maybe your XLSX file is already opened appeared first on The SAS Dummy.

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 Using ODS EXCEL and PROC EXPORT to bundle Excel-based reports appeared first on The SAS Dummy.

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 SAS […]

Do you use SAS for analytics and Excel for graphs?

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…

Query the Windows registry within your SAS program

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 […]

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

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 […]

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 CDISC […]