Part 3K: Using the Data

Preparing the SAS Table to Create a Graph:

Unfortunately, the SAS software at this time can only graph a time series of numbers that are evenly spaced, which we do not have.

  • BUT, we can do a work around to experience a sonified graph.
  • AND we can actually get data from the graph (and table) to determine the rotation period of Kleopatra.

Follow the steps below: (If you are using the Excel platform instead of the SAS Graphics Accelerator, your leader/teacher will have instructions for you)

The 1:59 video shows how to use SAS to make a sonified graph. Or, you can follow the instructions below the video.


Instructs for Preparing Data with SAS (same as video instructions)

A. Filter the Data

The file_id column (identifies the image) has evenly spaced numbers that we can use. BUT, there are two of each number (recall, one for the asteroid and one for the standard star).

  • We will filter the data and get rid of the double numbers, allowing us to use the file_id column as one of our axis.

Follow the steps below:

1. Find the column titled id (it is not the same as file_id!). It contains SRC, followed by a number.

  • There should be only two different numbers. We will filter for one of the numbers and eliminate the other row.

2. Previously you were told to click the “Save to Laboratory” button on the “Prepare Table” page. If you did this, the table now has additional information in row 2, either “Number” or Character”.

  • The id column has the word “Character” in row 2. Click on this. A pop-up box titled “column properties” appears .

3. Scroll down inside the box until you get to “Filter Column”.

4. Under the “Filter type”, choose “Ends with”.

5. Underneath this is a box titled “Value”. Type one of the numbers that occurs after the SRC into this box, and then click on “OK”.

  • This keeps all the rows with id value of SRC followed by the number you picked. This eliminates the double numbers in the file_id column. You should now have only 8 rows.

6. There is one more step to do before creating the graph. We must let the software know there is “series” data on the table that will be used for the graph.

  • This is in the “file_id” column. Click on the word “Number” in the second row of this column. It will bring up the “Column Properties” pop up box.

7. After the info box about the column type, there are 3 check boxes. Make sure the third box down, the one that says “This column contains series data” is checked. Then click “OK”. Now you are ready to create the graph.


B. Creating the Graph

The 1:18 video below gives instructions for making the sonified graph on SAS. Or use the instructions below the video.


Instructions to create graph follow instead of video:

1. Move back to the left of the page so that you see the choices above the table.

2. Click on “Create Table from Filtered Data”. A new page shows up.

3. Scroll down in the box under “Chart Type” until you see “Series Plot”. If it says its unavailable, go back and do step 6 and 7 above.

4. Below the chart type is the x axis variable and y axis variable. The x axis is chosen for you: file_id. You must choose the y axis. Scroll down under the y axis until you see delta mag. Click that.

5. Scroll down to the bottom to the very left and click “Submit”. This will take you back to the Table page.

6. Find the box below the button choices at the top. The box is a light green outline with the name of the graph inside it. Click this to open the sonified graph.

7. Once the new window opens, click on the graph so a light green box shows around the graph, and then explore by using the right and left arrow keys.

The next part will help in the exploration and interpretation of this graph.