Posts Tagged ‘ excel ’

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

How do I export from SAS to Excel files: Let me count the ways

February 11, 2012
By

I have a love-hate relationship with spreadsheet data. I am interested in finding data to analyze, and if it arrives in the form of a spreadsheet, I'll take it. And I like to deliver results and reports, but often my constituents ask for it as a spreadsheet that they can
Read more »

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

Behind the scenes: importing Excel files using SAS Enterprise Guide

May 18, 2011
By

I hope that the following statement is not too controversial...but here it goes: Microsoft Excel is not a database system. That is, I know that people do use it as a database, but it's not an application that supports the rigor and discipline of...
Read more »

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

Example 8.38: WriteXLS to create spreadsheets

May 16, 2011
By

In our last entry, we described reading Excel files. In this entry, we do the opposite: write native Excel files.RIn R, the WriteXLS package provides this functionality. It uses perl to do the heavy lifting, and the main complication is to install th...
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.