Tag: SAS

Date and datetime: accuracy vs storage and I/O costs (SAS)

How much storage space and I/O resources can be saved by using the LENGTH statement to shrink the storage of date and datetimes while maintaining sufficient precision? In my experience, saving I/O generally makes SAS run faster (such as in a DATA step)…

SAS Snippet: Reshape Data Using SAS DoW Loop (From Long to Wide)

In Art Carpenter’s latest book, Carpenter’s Guide to Innovative SAS Techniques, a data step approach to transpose data (from long to wide) works like (Ch2.4.2): data tst;     input type $ grp value $3.; datalines; A 1 a A 2 aa A 3 aaa B 1 b B 2 bb B 3 bbb C 1 […]

When and Where Do You Learn?

In a previous post, I mentioned a favourite interview question of mine: Stored Process Server vs Workspace Server – What’s the difference? I thought I’d mention another. Outside of incidental information picked-up through your regular work, how do yo…

R Tackles Big Garbage

April 1, 2013 – Although the capabilities of the R system for data analytics have been expanding with impressive speed, it has heretofore been missing important fundamental methods. A new function works with the popular plyr package to provide these missing … Continue reading

Data about each month (SAS)

A SAS code to generate information about each month such as the number of days in the month, week days, hours, work hours, etc. using intck and intnx function. It’s also a good example of using a DATA step to generate a data set without an input data …

NOTE: DS2 Final, Final Comments

I got as lot of feedback about the DS2 articles I recently wrote. I should add a few more summarising comments:

I mentioned that DS2 doesn’t currently support MERGE. Chris Hemedinger commented that the ability to use SQL in your SET statement means th…