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)…
Category: SAS
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 […]
Admins – Need to Restore One Metadata Object from a Backup?
When I think of corruption, it usually is more about government. Certainly, I don’t picture myself slipping a C-Note to the metadata server for favors, such as giving me special access or maybe ensuing my jobs have priority (wink). Stig Eide, a SAS BI administrator, reminds me that corruption does occur …
The post Admins – Need to Restore One Metadata Object from a Backup? appeared first on Business Intelligence Notes for SAS® BI Users. Written by Tricia Aanderud.
Coding in the fast lane with data-driven macro calls
The simple PRINT macro below prints a selected dataset: %macro print(data=&syslast,obs=5); proc print data=&data(obs=&obs); title "%upcase(&data)"; run; %mend print; Suppose you want to print every dataset in the…
Why Principle Component Analysis is always better than Factor Analysis?
Principle Component Analysis
If where and , and let , then where i the ith principal component and
Factor Analysis
if where , then and the common factors f are independent to .
For the two methods, the proportion of variance of explained…
Reach a personal milestone by getting your SAS certification
The SAS Global Certification program hit a significant milestone this year by awarding the 50,000th SAS credential. The program has come a long way since its launch 14 years ago. You can now validate your SAS skills in a variety of credentials includin…
Using SAS to count the number of LinkedIn "shares" for your article
Last year I shared this popular tip for counting how many times a web link has been shared on Twitter or Facebook. I use this technique daily to report on the social media “popularity” of our blog articles at SAS. I wanted to add LinkedIn into the mix. Like Twitter […]
SAS Enterprise Guide: Are You a Member of Programmers Anonymous?
Hi. My name is Quentin. I’m a SAS programmer. And I’m starting to like SAS Enterprise Guide.
In the years since SAS introduced Enterprise Guide, there has been a lot of controversy and hard feelings in the SAS programming community. Many programmers see Enterprise Guide as a tool for newbie programmers, …
The post SAS Enterprise Guide: Are You a Member of Programmers Anonymous? appeared first on Business Intelligence Notes for SAS® BI Users. Written by Quentin McMullen.