Title: Spelling Checker Utility in SAS® using VBA Macro and SAS® Functions
Abstract: In Pharmaceuticals/CRO industries, it is quite common to have typographical error during the data entry, data set programming, and table programming. This typographical error if not catch on time can add more programming/reviewer time and can affect the quality of deliverables. In order to find the misspelled words in SAS data set and tables, programmer normally review the data visually which can be tedious and prone to error. This paper will introduce a method to report all the misspelled word from table, listings, and SAS data set to a Word document in SAS using word basic commands via DDE (Dynamic Data Exchange) and SAS functions. If needed, this macro will be extended to find misspelled word from other file format for e.g. Microsoft Excel.
Publication Year: 2015
Publication Date: 2015-01-01
Language: en
Type: article
Access and Citation
AI Researcher Chatbot
Get quick answers to your questions about the article from our AI researcher chatbot