Tag: Uncategorized

Using LIBNAME XLSX to read and write Excel files

When you weren’t watching, SAS did it again. We smuggled Yet Another Excel Engine into a SAS release. SAS 9.2 Maintenance 2 added the XLSX engine, which allows you to read and write Microsoft Excel files as if they were data sets in a library. The big advantage of using […]

The post Using LIBNAME XLSX to read and write Excel files appeared first on The SAS Dummy.

Happy 35th anniversary, Mount St. Helens

Mount St. Helens volcano here in the US had a big eruption 35 years ago this week! Do you know exactly where it is located? Perhaps this SAS map can help… As you might have guessed, I’m a big fan of the awesome power of nature (hurricanes, tornadoes, lightning, earthquakes, and […]

The post Happy 35th anniversary, Mount St. Helens appeared first on The SAS Training Post.

Dataset too big for PROC PRINT?

Dataset too big for PROC PRINT? One weird trick solves your problem! proc print data=bigdata (obs=10); run; The OBS= dataset option specifies the last observation to process from an input dataset. In the above example, regardless of dataset size, only the first 10 observations are printed; an easy way to […]

The post Dataset too big for PROC PRINT? appeared first on The SAS Training Post.

A little fun with UFO sightings data

As a kid, I was always intrigued with UFO sightings and I guess I’m still a little that way … therefore how could I not jump at the opportunity to explore some UFO sightings data! I guess “UFO” doesn’t necessarily imply that something is an alien space ship – just […]

The post A little fun with UFO sightings data appeared first on The SAS Training Post.

Filter your SAS Enterprise Guide data with a WHERE clause

Are you a VIEWTABLE fan from the SAS Windowing Environment (a.k.a. Display Manager, DMS, PC SAS)? If so, the latest version of SAS Enterprise Guide has a new feature that you’ll love. With the latest update to SAS Enterprise Guide 7.1 (7.11), you can now subset your data in the […]

The post Filter your SAS Enterprise Guide data with a WHERE clause appeared first on The SAS Dummy.

Creating your own customized graphs for SAS analytic procedures

In recent releases of SAS, you can use Output Delivery System graphics or ‘ODS graphics on’ to produce nice graphical output for most of the analytic procedures. These default graphs are nice, but when you want your graphs to look “a certain way” SAS also lets you create your own custom graphs! […]

The post Creating your own customized graphs for SAS analytic procedures appeared first on The SAS Training Post.

Using FILENAME ZIP to unzip and read data files in SAS

I’ve written about how to use the FILENAME ZIP method to read and update ZIP files in your SAS programs. The ZIP method was added in SAS 9.4, and its advantage is that you can accomplish more in SAS without having to launch external utilities such as WinZip, gunzip, or […]

The post Using FILENAME ZIP to unzip and read data files in SAS appeared first on The SAS Dummy.

U.S. federal government is shrinking

I was surprised to find that the size of the U.S. federal government is smaller today, than in the past many decades – let’s graph it out, so it’s easy to analyze… The way I got started on this little adventure was via Jishai’s graph on dadaviz.com. Here’s a snapshot […]

The post U.S. federal government is shrinking appeared first on The SAS Training Post.