Oracle comments
Posted by Oleg Solovyev on Mar 27, 2010
There are two things that annoy me when coping data from other DBs into SAS. One can copy neither indexes nor field’s labels/comments. I don’t know what to do with indexes but there is a workaround for labels/comments.
The problem occurred after creation of the decision tree schema for presentation. There were no labels in the table copied from Oracle. Thus schema contained odd variable names instead of clear descriptions. But there were comments in Oracle but they were not copied with the data.
We decided to copy comments into a separate table and use a data step to set labels in the table with data.
SAS/Macro. Data step
Posted by Oleg Solovyev on Mar 8, 2010
Recently I worked on a data step that creates additional variables in a table that was downloaded from a data warehouse. Those variables were created for data analysis purposes. For instance calculated account age at delinquency can be more important than account start date or date of delinquency.
