Create a Data Source

To create a data source:
  1. Right-click the Data Sources folder in the Project Panel and select Create Data Source to open the Data Source wizard.
    Create Data Source
  2. Select SAS Table in the Source drop-down menu of the Metadata Source page.
  3. Click Next. The Select a SAS Table page opens.
  4. Click Browse.
  5. Click the SAS library named Mylib. The Mylib library folder contents are displayed on the Select a SAS Table dialog box.
    Note: If you do not see SAS data files in the Mylib folder, click Refresh.
    Library folder contents
  6. Select the VAEREXT table, and then click OK. The two-level name MYLIB.VAEREXT is displayed in the Table box of the Select a SAS Table page.
  7. Click Next. The Table Information page opens. The Table Properties pane displays metadata for you to review.
  8. Click Next. The Metadata Advisor Options page opens.
  9. Select Advanced, and then click Next. The Column Metadata page opens.
    Column Metadata window
  10. Select the following variable roles by clicking the role value for each variable value and selecting the indicated value from the drop-down list.
    • Set the role for V_ADMINBY to Input.
    • Set the role for V_FUNDBY to Input.
    • Set the role for costring to Text.
    • Set the role for serious to Target.
  11. Click Next. The Decision Configuration page opens.
  12. Click Next. The Data Source Attributes page opens.
  13. Click Next. The Summary page opens.
  14. Click Finish. The VAEREXT table is added to the Data Sources folder in the Project Panel.
Copyright © 2012 by SAS Institute Inc., Cary, NC, USA. All rights reserved.