Tag: Uncategorized

How to split one data set into many

Back in the day when the prison system forced inmates to perform “hard labor”, folks would say (of someone in prison): “He’s busy making little ones out of big ones.” This evokes the cliché image of inmates who are chained together, forced to swing a chisel to break large rocks […]

The post How to split one data set into many appeared first on The SAS Dummy.

SAS employees are now easier to spot on Communities

Since the launch of Communities on SAS, hundreds of SAS employees have been among you. Some SAS employees made themselves known by selecting a telling user name (such as Cynthia@SAS), but others remained camouflaged or incognito, keeping their secret identities like the SAS superheroes they are. That’s about to change. […]

The post SAS employees are now easier to spot on Communities appeared first on The SAS Dummy.

SAS is #1…In Plans to Discontinue Use

I’ve been tracking The Popularity of Data Analysis Software for many years now, and a clear trend is the decline of the market share of the bigger analytics firms, notably SAS and SPSS. Many people have interpreted my comments as implying … Continue reading

Using SAS Enterprise Guide with your local SAS installation

If you have SAS Enterprise Guide and SAS for Windows installed on a machine together, they should Just Work. There is no special setup required. But…what if they don’t? I’ve posted an article in the SAS Enterprise Guide community about this topic. Read the article to learn: How to select […]

The post Using SAS Enterprise Guide with your local SAS installation appeared first on The SAS Dummy.

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.

New SAS programming features in SAS Enterprise Guide 7.1

SAS Enterprise Guide 7.1 began shipping last week. Of the many new features, some are “biggies” while others are more subtle. My favorite new features are those for SAS programmers, including several items that I’ve heard customers ask for specifically. I’ll describe them briefly here; the SAS Enterprise Guide online […]

The post New SAS programming features in SAS Enterprise Guide 7.1 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.