2.4 Formatting Data

Sometimes data isn't in the best shape or in the right form when it is imported. Fortunately, JMP has extensive formatting abilities. This section focuses on the most common features, including:

• Cleaning up your data format, such as decimal places, dates, times, and currency. We will use the Column Info window to accomplish these tasks.

• Introducing the Formula Editor, which allows you to create new columns from old ones, add IF statements, and transform data using basic or more advanced functions. We will introduce a basic example in this section. For more information, select Help > Books > JMP User Guide.

• Learning to use the RECODE command, which is a handy way to merge similar categorical responses into a single category. For example, if you have Woman, Female, and Girl as responses, you can merge these into a single response, Female.