How to Prepare Your Data Sets

Determining the Structure and Contents of the Data Sets

To help determine how your data is related, look at the structure of the data sets. To see the structure, use the DATASETS procedure. To display the descriptor information, use the CONTENTS procedure. Descriptor information includes the number of rows in each data set, the name and attributes of each column, and an alphabetic list of extended attributes (including data set and column extended attributes). To print a sample of the rows, use the PRINT procedure or the REPORT procedure.

Testing Your Program

Create small temporary data sets that contain a sample of rows that test all of your program's logic. If your logic is faulty and you get unexpected output, you can debug your program.

Looking at Sources of Common Problems

If your program does not run correctly, review your input data for the following errors:
  • columns that have the same name but that represent different data
    To correct the error, you can rename columns before you combine the data sets by using the RENAME= table option in the SET or MERGE statement. As an alternative, use the DATASETS procedure to display all library management functions for all member types (except catalogs).
  • common columns that have the same data but different attributes
Last updated: January 10, 2018
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.189.186.109