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