Create and Execute a Job Using SAS Sample Data

Follow these steps to copy a small SAS sample table into Hadoop and execute a transformation on that data.
  1. Open SAS Data Loader and click the directive Copy Data to Hadoop.
  2. In the Source Table page, click the SAS Server data source.
    SAS Server Icon
  3. Click Sample Data.
    Sample Data Icon
  4. Click the CARS source table and click Next.
    CARS Source Table Icon
  5. In the Filter page, click Next to filter all SAS source rows into the Hadoop target table.
  6. In the Columns page, click Next to accept the existing number and arrangement of columns.
  7. In the Target Table page, click an appropriate location for what will be a new table.
  8. Click New Table icon and enter a table name such as SASCars2004.
    New Table in Target Table Page
  9. In the Code tab, browse the generated code, and then click Next.
  10. In the Result page, click Start copying data.
  11. Click View Results to see your new table in Hadoop.
  12. To transform your new table, click back to directives icon.
  13. In the Directives page, click Transform Data in Hadoop.
    Transform Data in Hadoop icon
  14. In the Source Table page, click the data source that you just used to store your new table.
  15. Click your new table, and then click Next.
    source table icon
  16. In the Transformations page, select Summarize Rows.
    Summarize Rows Icon
  17. Select group-by rows, summaries and aggregations, and then click Next.
    Summaries for Example
  18. In the Target Table page, click the data source that you use for target data, click New table icon, enter a table name, and then click Next.
  19. In the Result page, click Start transforming data. The job will run for a minute or so. Click View Results to see your first transformation in Hadoop using SAS Data Loader. Congratulations!
    Cars 2004 Summarized Table View
Copyright © SAS Institute Inc. All rights reserved.