Query the Windows registry within your SAS program

Chris Hemedinger
Chris Hemedinger|May 22, 2012

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

Post a Comment

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

Chris Hemedinger
Chris Hemedinger|May 1, 2012

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

Post a Comment

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

Chris Hemedinger
Chris Hemedinger|February 11, 2012

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

Post a Comment

Behind the scenes: importing Excel files using SAS Enterprise Guide

Chris Hemedinger
Chris Hemedinger|May 18, 2011

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 managing data in the same way [...]

Post a Comment

Who am I to judge?

Chris Hemedinger
Chris Hemedinger|January 19, 2011

Tomorrow I’ll be taking a few hours away from work to build something important: the self-esteems of a handful of middle-school-aged children. I’m volunteering as a judge in a middle-school science fair. And even though I’m not a scientist (“computer science” isn’t a category), I understand enough about physical science [...]

Post a Comment

Export to Excel 2007/2010 using SAS Enterprise Guide

Chris Hemedinger
Chris Hemedinger|October 1, 2010

Since its 4.2 release, SAS Enterprise Guide has been able to import Microsoft Excel 2007 and 2010 spreadsheet files (usually encountered as .XLSX files). But while SAS Enterprise Guide can export XLS files (which are compatible with all versions of Microsoft Excel), it does not have the ability to export [...]

Post a Comment

In the year 9999...

Chris Hemedinger
Chris Hemedinger|April 5, 2010

…if man is still alive, will he be importing Excel spreadsheets and wondering why his leap years are off? I received this report from SAS Technical Support, on behalf of a customer who uses SAS Enterprise Guide to import spreadsheet data: The date “12/31/9999″ will import as “02Jan****” when reading [...]

Post a Comment