topic creating a new variable in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/creating-a-new-variable/m-p/171643#M44262 <HTML><HEAD></HEAD><BODY><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Hi,</SPAN></P><P></P><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: Helvetica, sans-serif; background: white;">I</SPAN><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;"> am working with a long dataset consisting of school policy violation by students, The variables of interest for this question are: </SPAN></P><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;"><BR /></SPAN></P><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;"><EM>id</EM></SPAN></P><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;"><EM>incident_number</EM></SPAN></P><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;"><EM>incident_type </EM></SPAN></P><P style="margin-bottom: .0001pt;"><SPAN style="line-height: 1.5em; font-size: 12pt; font-family: 'Times New Roman', serif;"><EM>sanction.</EM></SPAN></P><P></P><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">I need to modify the dataset to create a new variable <EM>consult_sanction</EM> that consists of sanctions related to CONSULT (for instance, 00 Education – CONSULT Alcohol 1, 00 Education – CONSULT Drugs1).</SPAN></P><P></P><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Data Have</SPAN></P><P></P><TABLE border="1" cellpadding="0" cellspacing="0" style="border: none;"><TBODY><TR><TD style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="48"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">id</SPAN></P></TD><TD style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="78"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">incident_number</SPAN></P></TD><TD style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="126"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">incident_type</SPAN></P></TD><TD style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">sanction</SPAN></P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="48"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">1</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="78"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">2221</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="126"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Alcohol</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Parent Letter</SPAN></P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="48"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">1</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="78"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">2221</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="126"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Alcohol</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">00 Education – CONSULT Alcohol 1</SPAN></P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="48"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">1</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="78"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">2346</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="126"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Drugs</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">00 Education – CONSULT Drugs 1</SPAN></P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="48"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">2</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="78"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">2799</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="126"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Academic Dishonesty</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">00 Education – Reflection paper</SPAN></P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="48"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">2</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="78"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">2811</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="126"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Harassment</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Documentation only</SPAN></P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="48"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">3</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="78"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">2851</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="126"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Marijuana</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Parent Letter</SPAN></P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="48"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">3</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="78"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">2851</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="126"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Marijuana</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">00 Education – CONSULT Mari1</SPAN></P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="48"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">3</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="78"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">3214</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="126"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Marijuana</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Parent Letter</SPAN></P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="48"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">3</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="78"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">3214</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="126"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Marijuana</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">00 Education – CONSULT Mari2</SPAN></P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="48"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">3</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="78"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">3378</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="126"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Reckless Endangerment</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Probation</SPAN></P></TD></TR></TBODY></TABLE><P></P><P></P><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Data Want</SPAN></P><P></P><TABLE border="1" cellpadding="0" cellspacing="0" style="border: none;" width="624"><TBODY><TR><TD style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="48"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">id</SPAN></P></TD><TD style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="78"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">incident_number</SPAN></P></TD><TD style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="126"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">incident_type</SPAN></P></TD><TD style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">sanction</SPAN></P></TD><TD style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">consult_Sanction</SPAN></P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="48"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">1</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="78"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">2221</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="126"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Alcohol</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Parent Letter</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P></P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="48"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">1</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="78"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">2221</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="126"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Alcohol</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">00 Education – CONSULT Alcohol 1</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">00 Education – CONSULT Alcohol 1</SPAN></P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="48"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">1</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="78"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">2346</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="126"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Drugs</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">00 Education – CONSULT Drugs 1</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">00 Education – CONSULT Drugs 1</SPAN></P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="48"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">2</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="78"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">2799</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="126"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Academic Dishonesty</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">00 Education – Reflection paper</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P></P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="48"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">2</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="78"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">2811</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="126"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Harassment</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Documentation only</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P></P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="48"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">3</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="78"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">2851</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="126"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Marijuana</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Parent Letter</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P></P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="48"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">3</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="78"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">2851</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="126"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Marijuana</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">00 Education – CONSULT Mari1</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">00 Education – CONSULT Mari1</SPAN></P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="48"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">3</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="78"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">3214</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="126"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Marijuana</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Parent Letter</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P></P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="48"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">3</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="78"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">3214</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="126"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Marijuana</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">00 Education – CONSULT Mari2</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">00 Education – CONSULT Mari2</SPAN></P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="48"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">3</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="78"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">3378</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="126"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Reckless Endangerment</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Probation</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P></P></TD></TR></TBODY></TABLE><P></P><P></P><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Thank you for your help!</SPAN></P></BODY></HTML> Tue, 17 Feb 2015 06:46:31 GMT Angi 2015-02-17T06:46:31Z creating a new variable https://communities.sas.com/t5/SAS-Procedures/creating-a-new-variable/m-p/171643#M44262 <HTML><HEAD></HEAD><BODY><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Hi,</SPAN></P><P></P><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: Helvetica, sans-serif; background: white;">I</SPAN><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;"> am working with a long dataset consisting of school policy violation by students, The variables of interest for this question are: </SPAN></P><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;"><BR /></SPAN></P><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;"><EM>id</EM></SPAN></P><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;"><EM>incident_number</EM></SPAN></P><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;"><EM>incident_type </EM></SPAN></P><P style="margin-bottom: .0001pt;"><SPAN style="line-height: 1.5em; font-size: 12pt; font-family: 'Times New Roman', serif;"><EM>sanction.</EM></SPAN></P><P></P><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">I need to modify the dataset to create a new variable <EM>consult_sanction</EM> that consists of sanctions related to CONSULT (for instance, 00 Education – CONSULT Alcohol 1, 00 Education – CONSULT Drugs1).</SPAN></P><P></P><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Data Have</SPAN></P><P></P><TABLE border="1" cellpadding="0" cellspacing="0" style="border: none;"><TBODY><TR><TD style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="48"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">id</SPAN></P></TD><TD style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="78"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">incident_number</SPAN></P></TD><TD style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="126"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">incident_type</SPAN></P></TD><TD style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">sanction</SPAN></P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="48"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">1</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="78"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">2221</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="126"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Alcohol</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Parent Letter</SPAN></P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="48"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">1</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="78"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">2221</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="126"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Alcohol</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">00 Education – CONSULT Alcohol 1</SPAN></P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="48"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">1</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="78"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">2346</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="126"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Drugs</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">00 Education – CONSULT Drugs 1</SPAN></P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="48"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">2</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="78"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">2799</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="126"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Academic Dishonesty</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">00 Education – Reflection paper</SPAN></P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="48"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">2</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="78"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">2811</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="126"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Harassment</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Documentation only</SPAN></P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="48"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">3</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="78"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">2851</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="126"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Marijuana</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Parent Letter</SPAN></P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="48"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">3</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="78"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">2851</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="126"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Marijuana</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">00 Education – CONSULT Mari1</SPAN></P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="48"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">3</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="78"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">3214</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="126"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Marijuana</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Parent Letter</SPAN></P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="48"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">3</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="78"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">3214</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="126"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Marijuana</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">00 Education – CONSULT Mari2</SPAN></P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="48"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">3</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="78"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">3378</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="126"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Reckless Endangerment</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Probation</SPAN></P></TD></TR></TBODY></TABLE><P></P><P></P><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Data Want</SPAN></P><P></P><TABLE border="1" cellpadding="0" cellspacing="0" style="border: none;" width="624"><TBODY><TR><TD style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="48"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">id</SPAN></P></TD><TD style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="78"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">incident_number</SPAN></P></TD><TD style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="126"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">incident_type</SPAN></P></TD><TD style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">sanction</SPAN></P></TD><TD style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">consult_Sanction</SPAN></P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="48"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">1</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="78"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">2221</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="126"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Alcohol</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Parent Letter</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P></P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="48"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">1</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="78"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">2221</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="126"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Alcohol</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">00 Education – CONSULT Alcohol 1</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">00 Education – CONSULT Alcohol 1</SPAN></P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="48"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">1</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="78"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">2346</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="126"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Drugs</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">00 Education – CONSULT Drugs 1</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">00 Education – CONSULT Drugs 1</SPAN></P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="48"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">2</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="78"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">2799</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="126"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Academic Dishonesty</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">00 Education – Reflection paper</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P></P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="48"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">2</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="78"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">2811</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="126"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Harassment</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Documentation only</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P></P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="48"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">3</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="78"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">2851</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="126"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Marijuana</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Parent Letter</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P></P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="48"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">3</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="78"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">2851</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="126"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Marijuana</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">00 Education – CONSULT Mari1</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">00 Education – CONSULT Mari1</SPAN></P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="48"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">3</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="78"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">3214</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="126"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Marijuana</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Parent Letter</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P></P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="48"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">3</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="78"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">3214</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="126"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Marijuana</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">00 Education – CONSULT Mari2</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">00 Education – CONSULT Mari2</SPAN></P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="48"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">3</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="78"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">3378</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="126"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Reckless Endangerment</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Probation</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="186"><P></P></TD></TR></TBODY></TABLE><P></P><P></P><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Thank you for your help!</SPAN></P></BODY></HTML> Tue, 17 Feb 2015 06:46:31 GMT https://communities.sas.com/t5/SAS-Procedures/creating-a-new-variable/m-p/171643#M44262 Angi 2015-02-17T06:46:31Z Re: creating a new variable https://communities.sas.com/t5/SAS-Procedures/creating-a-new-variable/m-p/171644#M44263 <HTML><HEAD></HEAD><BODY><P>Can't FIND() make it happen ?</P><P></P><P>if&nbsp; find(<SPAN style="font-family: 'Times New Roman', serif; font-size: 16px; background-color: #ffffff;">sanction,'<SPAN style="font-family: 'Times New Roman', serif; font-size: 16px; background-color: #ffffff;">CONSULT</SPAN>') then <SPAN style="font-family: 'Times New Roman', serif; font-size: 16px; background-color: #ffffff;">consult_Sanction=<SPAN style="font-family: 'Times New Roman', serif; font-size: 16px; background-color: #ffffff;">sanction ; </SPAN></SPAN></SPAN></P></BODY></HTML> Tue, 17 Feb 2015 07:05:51 GMT https://communities.sas.com/t5/SAS-Procedures/creating-a-new-variable/m-p/171644#M44263 Ksharp 2015-02-17T07:05:51Z Re: creating a new variable https://communities.sas.com/t5/SAS-Procedures/creating-a-new-variable/m-p/171645#M44264 <HTML><HEAD></HEAD><BODY><P>It worked. Thank you very much!</P></BODY></HTML> Tue, 17 Feb 2015 08:06:26 GMT https://communities.sas.com/t5/SAS-Procedures/creating-a-new-variable/m-p/171645#M44264 Angi 2015-02-17T08:06:26Z