https://communities.sas.com/t5/SAS-Programming/Extract-value-when-preceding-variable-has-a-specific-value/m-p/812081#M320385 <P>Please post data in usable from (data step with datalines) and the expected result.</P> <P>It is not clear what you want to create, maybe the MET-variables?</P> <P>If that is the case, using compress to remove non-digits and input to create numbers seem to be a good choice.</P> Mon, 09 May 2022 06:13:13 GMT andreas_lds 2022-05-09T06:13:13Z https://communities.sas.com/t5/SAS-Programming/Extract-value-when-preceding-variable-has-a-specific-value/m-p/812023#M320355 <DIV class=""><DIV class="">&nbsp;</DIV></DIV><DIV class=""><DIV class=""><DIV class=""><P><SPAN>Can someone help me with a SAS code where a variable,&nbsp;</SPAN><SPAN class="">MET, extract the numbers of the second variable, if one of the variables CODE_1-CODE_44 contains one of several codes (T1b, T4a, T3a) and that the first subsequent variable (of CODE_1-CODE_44) contains a 6-character code&nbsp; that starts with "LND" (LND001-LND200).&nbsp;&nbsp;</SPAN></P><P>&nbsp;</P><P><SPAN class="">CODE_1&nbsp; CODE_2 CODE_3 CODE_4&nbsp; &nbsp; &nbsp; &nbsp;CODE_5&nbsp; &nbsp; &nbsp; &nbsp; MET.1&nbsp; MET.2&nbsp;</SPAN></P><P><SPAN class="">T1b&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;LND022&nbsp; &nbsp; &nbsp;C2a&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;P4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; T6B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;22&nbsp; &nbsp; &nbsp; &nbsp; .&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</SPAN></P><P><SPAN class="">T4a&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;M4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; C2a&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;T4a&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; LND020&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20&nbsp; &nbsp; &nbsp; &nbsp; .&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN></P><P><SPAN class="">T4a&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;LND001&nbsp; &nbsp; &nbsp;T1b&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;LND044&nbsp; &nbsp; &nbsp; &nbsp;LND032&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; 44&nbsp; &nbsp; &nbsp; &nbsp;</SPAN></P></DIV></DIV></DIV> Sun, 08 May 2022 18:30:19 GMT https://communities.sas.com/t5/SAS-Programming/Extract-value-when-preceding-variable-has-a-specific-value/m-p/812023#M320355 MABRINCH 2022-05-08T18:30:19Z https://communities.sas.com/t5/SAS-Programming/Extract-value-when-preceding-variable-has-a-specific-value/m-p/812081#M320385 <P>Please post data in usable from (data step with datalines) and the expected result.</P> <P>It is not clear what you want to create, maybe the MET-variables?</P> <P>If that is the case, using compress to remove non-digits and input to create numbers seem to be a good choice.</P> Mon, 09 May 2022 06:13:13 GMT https://communities.sas.com/t5/SAS-Programming/Extract-value-when-preceding-variable-has-a-specific-value/m-p/812081#M320385 andreas_lds 2022-05-09T06:13:13Z