logo Getting Started with SAS Enterprise Guide Main menubacknext
    

Specify Field Attributes

Remember that from this text file you want to create a SAS data set that has two columns: CategoryID and CategoryName. In these steps you change the labels for two columns and eliminate the Description column.

  1. In the table of column attributes, column F1 is already selected. Click Modify to open the Field Attributes for F1 window.

    2. Define Field Attributes page

  2. In the Name box, type CategoryID.


  3. In the Label box, type Category ID. Make sure that Type is set to Number and click OK.

Field Attributes dialog box

  1. In the Name column, click F2 twice to edit the field and type CategoryName.


  2. In the Label column, click F2 twice to edit the field and type Product Category.

Setting properties for the CategoryName column
Click to view the full window.


  1. In the Inc column, clear the check box for column F3 to exclude this column from the data set. Because you don't need to have a column in your data set that contains this information, you can eliminate it from the import process.

Setting properties for the Description column
Click to view the full window.


  1. Click Next to see the advanced options, and then run the task to import the data.

 

Main menubacknext