title: Split string into multiple variables
body: <p>I have dataset that looks like this:</p>
  
  <pre><code>Var1
  PASSED=50; NOT PASSED=10; GPA=1;
  </code></pre>
  
  <p>How can I produce the dataset below?</p>
  
  <pre><code>Pass     Not_pass      GPA  
    50           10        1
  </code></pre>
  
  <p>I used the following code but it did not work:</p>
  
  <pre><code>generate pass = subinstr(subinstr(word(Var1, 1), "PASSED=", "", .) if regexm(Var1, "PASSED=") == 1
  replace pass = pass[_n+1] if pass[_n]=="" &amp; pass[_n+1]!=""
  </code></pre>