Hi, I wanted to follow up on this question as this is something near and dear to my heart - test-first design (TFD) and automated unit testing.  Philosophically, methodologies that take advantage of robust development processes are critical IMHO. Most SAS Programmers are not Developers - that is, most write their programs against the data, whereas Developers write their programs against requirements.  That distinction is very important in determining whether you (or your organization) have the support that you will need to utilize TFD.  The reason being is that this will require discipline and commitment to the approach. With that being said, I have included some references to our thinking on how you can/ should implement TFD in your SAS programming practices. FUTS - an open source framework for Unit Testing in SAS Using FUTS with Test First Design - SGF/ SUGI Paper Unit Testing Frameworks for SAS (Wiki) Robustness in SAS Applications (PhUSE Wiki) Hope this helps. -greg -greg ... View more

Got it, i saw your table with the first column and thot that was the field you could use.  it would be pretty tough without knowing whether it was a dx or not.  In the market scan data, we usually have dx1 -- dx15 and similar fields for procs. I would go back to the data owner and see if there is another option to understanding logic that you should use as others have suggested. -greg ... View more

Hi I'm curious about your question since it would appear that we have all of the components that we need to accurately record each of the values.  We have a field which tells us whether this is a diagnosis or procedure, we have the rule indicating whether or not we should position the decimal after the third or second character. I assume you are trying to match the icd-9 column with the market scan value?  why not drop the decimal in your transform then use the positional logic based on proc vs. dx to recode the variable? If i missed something critical i apologize. Happy to work up an example if that is really what you need. -greg ... View more