How to convert an SPSS Macro which checks for Numbers to check for a Letter and a Number?
<p>Working with an SPSS spreadsheet that contains mixed data. One column contains varied numeric entries by row. I wrote a simple macro that has the following behavior.</p>

<ol>
<li>Checks each Row for a given numeric entry in a column.</li>
<li>A new column is then created and, if the numeric entry is in the row it is assigned a 1. If not it is assigned 0. </li>
</ol>

<p>The code is as follows: </p>

<pre><code>DEFINE INCHECK (!POSITIONAL !TOKENS(1)
/!POSITIONAL !CMDEND)

NUMERIC !1.
COUNT !1=IN1 TO IN15 (!2).
IF !1 GT 0
!1=1.
!ENDDEFINE
</code></pre>

<p>The problem is as follows. I now have a new dataset which has an additional column with data like "E1567, G4345, etc." I would like to adjust the macro to be able to have the same behavior with this different type of entry. I've though about converting the entries, but am unsure how to accomplish this in SPSS. Any thoughts? </p>