Running a Single Log Job

Problem

You want to process a single clickstream log.

Solution

You can process the job in the single log job template. If you have not done so already, you should run a copy of the setup job for the single log template, which is named clk_0010_setup_basic. When you actually process the data, you should run a copy of the single log job, which is named clk_0200_create_output_details. By running a copy, you protect the original template. For information about running the setup job and creating a copy of the original job, see Copying the Sub Site Templates Folder.

Tasks

Review and Prepare the Job

You can examine the single log job on the Diagram tab of the SAS Data Integration Studio Job Editor before you run it. You can also specify the location of the clickstream log to process.
Perform the following steps to review and prepare the job:
  1. Open the renamed single log job.
  2. Scroll through the job on the Diagram tab and review the following items:
    • the section that processes the source clickstream log
    • the section that parses the data into meaningful columns
    • the section that creates sessions and generates an output table
  3. Open the File Location tab in the properties window for the Clickstream Log transformation and review the file path to the clickstream log in the File name field. Specify another path if you need to process a different log. Click OK to close the properties window when you are finished.
    Note: You can click the Preview button to view the first few lines of the file and confirm that you have selected a valid path.

Run the Job and Examine the Output

Perform the following steps to run a single log job and examine its output:
  1. Run the job.
    The following display shows a successfully completed sample job.
    Completed Single Log Job
    Completed Single Log Job
  2. If the job completes without error, right-click the OUTPUT_DETAIL table at the end of the job and click Open in the pop-up menu.
    The View Data window appears, as shown in the following display.
    Single Log Job Output
    Single Log Job Output
Copyright © SAS Institute Inc. All rights reserved.