title: How to manipulate sas7bdat files?
body: <p>I'm working with a sas7dbat file that was created erroneously and trying to fix it. When the file was created, the data was all input unto a single column instead of multiples, and I can't figure out how to manipulate it to do this. I thought I'd be able to use infile and make the dlm &quot;|&quot; with dsd to remove the quotations on the name column, but it seems that this problem is harder than it looks.</p>
  <p>I basically want to turn that one column into the six it was supposed to be and delete the quotations from the names. Here's what it looks like in SAS:</p>
  <p><a href="https://i.stack.imgur.com/WL7EM.png" rel="nofollow noreferrer">SAS7dbat</a></p>
  <p>And here's the datalines in case they're needed:</p>
  <p>1   0017|2020-04-09|&quot;Jason Nguyen&quot;|122L|500.0|$404.82</p>
  <p>2   0017|2020-04-09|&quot;Jason Nguyen&quot;|407XX|100.0|$201.95</p>
  <p>3   0177|2020-04-05|&quot;Glenda Johnson&quot;|144L|100.0|$91.01</p>
  <p>4   0177|2020-04-05|&quot;Glenda Johnson&quot;|188X|100.0|$70.76</p>
  <p>5   0177|2020-04-05|&quot;Glenda Johnson&quot;|733|2.0|$101,230.00</p>
  <p>6   0177|2020-04-05|&quot;Glenda Johnson&quot;|777|5.0|$106.29</p>
  <p>7   1843|2020-04-03|&quot;George Smith&quot;|122|100.0|$60.64</p>
  <p>8   1843|2020-04-03|&quot;George Smith&quot;|122L|10.0|$303.18</p>
  <p>9   1843|2020-04-03|&quot;George Smith&quot;|144L|50.0|$91.01</p>
  <p>10  1843|2020-04-03|&quot;George Smith&quot;|188S|3.0|$52,629.48</p>
  <p>11  1843|2020-04-03|&quot;George Smith&quot;|855W|1.0|$92,210.41</p>
  <p>12  1843|2020-04-03|&quot;George Smith&quot;|908X|1.0|$51,920.87</p>
  <p>13  9888|2020-04-11|&quot;Sharon Lu&quot;|100W|1,000.0|$20.14</p>
  <p>14  9888|2020-04-11|&quot;Sharon Lu&quot;|122|50.0|$60.64</p>
  <p>(each line is one column inside SAS)</p>