By Ron Cody
Please remember that there's a moment version of this ebook (at a similar price). as a result, make sure you purchase the second one version and never the unique. here's a hyperlink to the second one variation: Cody's facts cleansing innovations utilizing SAS, moment Edition.
I have rewritten each application and each macro within the re-creation. There also are many extra beneficial macros to be had (you can obtain them from the SAS internet site). additionally new is a bankruptcy on SAS integrity constraints and audit trails.
Read or Download Cody's Data Cleaning Techniques Using SAS Software PDF
Best enterprise applications books
Office 2016 All-In-One For Dummies
The short and straightforward technique to get issues performed with workplace at a loss for words by way of PowerPoint? seeking to excel at Excel? From entry to be aware and each program in among this all-encompassing advisor offers plain-English suggestions on learning the whole Microsoft place of work suite. via easy-to-follow guide, you'll speedy wake up and operating with Excel, note, PowerPoint, Outlook, entry, writer, Charts and photographs, OneNote, and extra and make your paintings and residential lifestyles more straightforward, extra effective, and extra streamlined.
Emerging Topics and Technologies in Information Systems
This day, the data structures (IS) self-discipline faces new demanding situations. rising applied sciences in addition to matured methods for the social, technical, and developmental function of IS supply a brand new context for the evolution of the self-discipline over the following few years. rising themes and applied sciences in details structures communicates the demanding situations and possibilities that info structures examine is facing this day whereas selling state of the art learn on how present IS aid is developing the severe spine for the data society.
Exchange 2010 SP1 - A Practical Approach
Alternate Server 2010 provider Pack 1 is the newest incarnation of Microsoft's Messaging and Collaboration platform, and is has loads of new, compelling positive aspects. it's the 7th significant model of the product, and it rolls out a few vital adjustments and many small advancements. Even higher, loads of complicated concerns from prior models have obvious solved, or just got rid of, making the administrator's existence a lot more uncomplicated!
Additional info for Cody's Data Cleaning Techniques Using SAS Software
Sample text
15 HR HR_CK3. @18 SBP SBP_CK3. ; IF HR = 8888 THEN PUT PATNO= "Invalid character value for HR"; ELSE IF HR NE 9999 THEN PUT PATNO= HR=; IF SBP = 8888 THEN PUT PATNO= "Invalid character value for SBP"; ELSE IF SBP NE 9999 THEN PUT PATNO= SBP=; IF DBP = 8888 THEN PUT PATNO= "Invalid character value for DBP"; ELSE IF DBP NE 9999 THEN PUT PATNO= DBP=; RUN; The UPCASE option converts any character values to uppercase before it is determined if the value fits into one of the specified ranges. Notice that the ranges for the three informats contain both numeric ranges and character ranges.
Extra parentheses do no harm. Chapter 2 Checking Values of Numeric Variables 33 The resulting output is shown next. Out-of-Range Values for Numeric Variables PATNO HR SBP DBP 004 008 009 010 011 014 017 321 020 023 101 210 86 . 68 22 208 900 10 22 200 . 240 40 300 130 . 400 20 34 120 . 180 120 20 90 84 200 8 78 A disadvantage of this listing is that an observation is printed if one or more of the variables is outside the specified range. To obtain a more precise listing that shows only the data values outside the normal range, you can use a DATA step as described in the next section.
A macro program is a piece of SAS code where parts of the code are substituted with variable information by the macro processor before the code is processed in the usual way by the SAS compiler. The macro in Program 2-7 is named RANGE, and it begins with a %MACRO statement and ends with a %MEND (macro end) statement. The first line of the macro contains the macro name, followed by a list of arguments. When the macro is called, the macro processor replaces each of these arguments with the values you specify.