Forum Discussion
Creating columns from summarized data in other tables
I have two datasets. One is enrollment information that states whether students that were enrolled in the fall semester are enrolled in the spring. The second lists all of the financial aid that stud...
I figured out that I can concatenate student ID and term and use that variable to match the datasets, so the pairing by student ID AND term isn't really necessary to solve this. The below tables show what I'm trying to do. I need the info from Table 1 to be summarized into Table 2. This is what I'm going for:
Table 1
| Student | Award |
| A | 1 |
| A | 2 |
| A | 3 |
| B | 2 |
| B | 4 |
| C | 1 |
| C | 2 |
| C | 3 |
| C | 4 |
Table 2
| Student | Received Award 1? |
| A | Yes |
| B | No |
| C | Yes |