title: Split one string into multiple rows (SAS)
body: <p>I'm trying to do the following in SAS.</p>
  
  <p>I have a dataset like this:</p>
  
  <pre><code>| F2                                  | F3     | PERIOD   |
  ___________________________________________________________
  | Text1(1001) Text2(1002) Text3(1003) |        | 10-02-03 |
  | Text4                               | 1004   | 10-02-08 |
  | Text5(1005) Text6(1006)             |        | 10-02-12 |
  | Text7                               | 1007   | 10-03-01 |
  </code></pre>
  
  <p>What I would like to do is splitting the F2-column up if there is more than one value. So the dataset would look like this:</p>
  
  <pre><code>| F2                                  | F3     | Period   |
  ___________________________________________________________
  | Text1                               | 1001   | 10-02-03 |
  | Text2                               | 1002   | 10-02-03 |
  | Text3                               | 1003   | 10-02-03 |
  | Text4                               | 1004   | 10-02-08 |
  | Text5                               | 1005   | 10-02-12 |
  | Text6                               | 1006   | 10-02-12 |
  | Text7                               | 1007   | 10-03-01 |
  </code></pre>
  
  <p>So the values in the parentheses ends in the F3 Column and the PERIOD column stays the same.</p>
  
  <p>I hope somebody can help.</p>