During my initial stay in US last year, one of the interesting exercises was to write a check. The Arabic numerals (the universal language!) were pretty intuitive while I didn’t feel much comfortable on spelling the face value in words: I never played the game! But the good side of this story was, as a […]
Category: SAS
Using Windows PowerShell to connect to a SAS Metadata Server
SAS Integration Technologies provides a flexible platform to create all types of apps, from simple utilities to full-blown applications. As part of the research for my SAS Global Forum 2013 paper (Create Your Own Client Apps Using SAS Integration Technologies), I’ve been trying to invent some useful examples that you […]
SAS analysis of the #1 most popular baby names
I’m sure that most of you have seen the really cool interactive Baby Name Voyager, right? If not, go have a look and try it out (be sure to plug in your name, and the names in your family, and so on). That’s a pretty cool application! … But it m…
Github for Clinical/Statistical Programmers
PhUSE-FDA Working Group 5 (Development of Standard Scripts for Analysis and Programming) just adopted Google Code as collaborative programming platform. Google Code is one of the most popular and respected open source software hosting sites in the world and it is definitely a good choice for PhUSE-FDA WG5. But after viewing one of WG5’s working […]
Two tips for importing and exporting data between SAS Enterprise Guide and Microsoft Excel
In his first SAS® Enterprise Guide® Tip, instructor David Ghan teaches how to import and combine data from multiple Microsoft Excel sheets. Then, in his second tip, he shows the alternative approach – how to export groups of data to separate sheets…
SAS Stored Processes: Querying a Stored Process from Excel without the Add-In
What do I have in common with a guy in Norway? Well, if you look at my last name Aanderud – you might think he is a family member. Turns out Stig Eide and I both use SAS Stored Processes to solve issues! Recently this SAS platform administrator asked if he …
The post SAS Stored Processes: Querying a Stored Process from Excel without the Add-In appeared first on Business Intelligence Notes for SAS® BI Users. Written by Tricia Aanderud.
NOTE: DS2, Final Comments
In my previous posts, I’ve covered many aspects of DS2 (previous posts are listed at the bottom of this post). It’s time to wrap up by offering a few more final details.
Whilst DS2 provides a wide range of data types, not all types are supported by all…
Linguistic Sorting in SAS Proc Sort
Just took a look at the linguistic sorting features in SAS Sort procedure, and got some neat options to apply to my task. For example, I want to sort ID in the following dataset: data t1; input ID $ ; datalines; T20 T4 T3 T1 ; and want to get such intuitive orderings (files […]