In a comment in response to my recent Testing – Discipline article, Rick@SAS provided a link to an article he’d posted on the American Statistical Association community forum wherein he drew an analogy between testing and going to the dentist. I think …
NOTE: Testing is Like Visiting the Dentist?
In a comment in response to my recent Testing – Discipline article, Rick@SAS provided a link to an article he’d posted on the American Statistical Association community forum wherein he drew an analogy between testing and going to the dentist. I think …
NOTE: Testing (With Basic Macros)
So, having stressed the importance of testing in my previous post on the subject, let me give you some hints on how I keep the test phase efficient and effective on my projects. This will be a series of hints across the next few days. Today I’ll offer …
NOTE: Testing (With Basic Macros)
So, having stressed the importance of testing in my previous post on the subject, let me give you some hints on how I keep the test phase efficient and effective on my projects. This will be a series of hints across the next few days. Today I’ll offer …
Links for 2011-11-23 [del.icio.us]
SAS Info Map: Need leading zeros on the account number?
SAS Info Map: Need leading zeros on the account number?
When creating new variables, the SAS Information Map Studio opens the entire SAS format library to you. These formats can be key to creating lots of new data items. SAS format control the way data items appear. In past articles I showed you how to create new data item using SAS functions and date formats. Check the SAS documentation to learn more about all the different formats available. Creating new Data Items in SAS Information Map Studio When data has been merged from various companies, such as when one company acquires another one, their data may be in different formats. For instance, account numbers might vary from 8 characters in one company and 12 characters wide in the other. When this occurs one option is to use the widest account number and add zeros to the front of the smaller one to integrate the fields better. You can do this easily within the information map using the Z format. From SAS Information Map Studio, you can create or modify the existing variable. In this case I have two account numbers – 1 where there are only 3 characters and the other with 5 characters. The end result should be […]