topic Re: how to check QA of protocol variable ,. in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/how-to-check-QA-of-protocol-variable/m-p/834340#M82054 <P>Code provided here:&nbsp;<A href="https://communities.sas.com/t5/SAS-Programming/verify-the-format/td-p/834130" target="_blank">https://communities.sas.com/t5/SAS-Programming/verify-the-format/td-p/834130</A></P> Tue, 20 Sep 2022 17:58:44 GMT PaigeMiller 2022-09-20T17:58:44Z how to check QA of protocol variable ,. https://communities.sas.com/t5/SAS-Procedures/how-to-check-QA-of-protocol-variable/m-p/834246#M82051 <TABLE><TBODY><TR><TD>Protcol ID/NO</TD><TD>Site ID</TD><TD>Subject Id</TD><TD>DOB</TD><TD>Acc NO.</TD><TD>SC Date</TD></TR><TR><TD>ONC_AP/01234-1</TD><TD>101</TD><TD>ABC</TD><TD>15-Jul-78</TD><TD>2345671671</TD><TD>16/09/22</TD></TR><TR><TD>ONC_AP/01234-2</TD><TD>102</TD><TD>BBC</TD><TD>21-Jun-87</TD><TD>9900696375</TD><TD>18/09/22</TD></TR><TR><TD>ONC_AP/01234-3</TD><TD>103</TD><TD>BBD</TD><TD>10-Sep-03</TD><TD>6474893763</TD><TD>17/09/22</TD></TR><TR><TD>ONC_AP/01234-4</TD><TD>104</TD><TD>BAC</TD><TD>18/08/90</TD><TD>7653225839</TD><TD>16/09/22</TD></TR><TR><TD>ONC_AP/01234-5</TD><TD>105</TD><TD>ACF</TD><TD>16/07/50</TD><TD>6432875875</TD><TD>14/09/22</TD></TR><TR><TD>ONC_AP/01234-6</TD><TD>101</TD><TD>TGU</TD><TD>16/08/55</TD><TD>5627483920</TD><TD>19/09/22</TD></TR><TR><TD>ONC_AP/01234-7</TD><TD>102</TD><TD>JKL</TD><TD>12/07/08</TD><TD>3456098347</TD><TD>18/09/22</TD></TR><TR><TD>ONC_AP/01234-8</TD><TD>101</TD><TD>AFN</TD><TD>23/02/80</TD><TD>8765234509</TD><TD>18/09/22</TD></TR><TR><TD>ONC_AP/01234-9</TD><TD>104</TD><TD>SLR</TD><TD>07/05/86</TD><TD>5647389098</TD><TD>17/09/22</TD></TR><TR><TD>ONC_AP/01234-10</TD><TD>105</TD><TD>ASR</TD><TD>19/12/83</TD><TD>2345671671</TD><TD>18/09/22</TD></TR><TR><TD>ON1_AP/01234-2</TD><TD>10A</TD><TD>_ABC</TD><TD>12-Jul-78</TD><TD>9900696375</TD><TD>19/09/22</TD></TR><TR><TD>O1C_AP/01234-2</TD><TD>A02</TD><TD>1BC</TD><TD>20-Jun-87</TD><TD>6474893763</TD><TD>18/09/22</TD></TR><TR><TD>1NC_AP/01234-4</TD><TD>#03</TD><TD>_1BD</TD><TD>10-Sep-03</TD><TD>7653225839</TD><TD>19/09/22</TD></TR><TR><TD>ONC1_AP/01234-6</TD><TD>1Q4</TD><TD>_111</TD><TD>18/08/90</TD><TD>6432875875</TD><TD>15/09/22</TD></TR><TR><TD>ONC_1P/01234-6</TD><TD>ab5</TD><TD>AC-</TD><TD>16/07/50</TD><TD>5627483920</TD><TD>13/09/22</TD></TR><TR><TD>ONC_A1/01234-7</TD><TD><A href="mailto:a@c" target="_blank" rel="noopener">a@c</A></TD><TD>101_TGU</TD><TD>16/08/55</TD><TD>3456098347</TD><TD>16/09/22</TD></TR><TR><TD>ONC-01/01234-7</TD><TD>aaa</TD><TD>102-JKL</TD><TD>12/07/08</TD><TD>8765234509</TD><TD>19/09/22</TD></TR><TR><TD>ONC_#P/01234-9</TD><TD>a0a</TD><TD><A href="mailto:103@AFN" target="_blank" rel="noopener">103@AFN</A></TD><TD>23/02/80</TD><TD>5647389098</TD><TD>15/09/22</TD></TR><TR><TD>ONC_AP*01234-10</TD><TD>#3#</TD><TD>102_a10-</TD><TD>07/05/86</TD><TD>2345671671</TD><TD>17/09/22</TD></TR><TR><TD>ONC_AP/A1234-2</TD><TD>10_</TD><TD>ASR_100</TD><TD>19/12/83</TD><TD>9900696375</TD><TD>19/09/22</TD></TR><TR><TD>ONC_AP/0A234-1</TD><TD>101-</TD><TD>/scf</TD><TD>15-Sep-78</TD><TD>6474893763</TD><TD>16/09/22</TD></TR><TR><TD>ON1_AP/01A34-2</TD><TD>106</TD><TD>ACY</TD><TD>21-Mar-87</TD><TD>7653225839</TD><TD>18/09/22</TD></TR><TR><TD>O1C_AP/012A4-2</TD><TD>107</TD><TD>BBE</TD><TD>10-Mar-03</TD><TD>6432875875</TD><TD>17/09/22</TD></TR><TR><TD>1NC_AP/0123A-4</TD><TD>108</TD><TD>BBY</TD><TD>18/01/90</TD><TD>5627483920</TD><TD>16/09/22</TD></TR><TR><TD>ONC1_AP/01234_6</TD><TD>109</TD><TD>AAC</TD><TD>16/02/50</TD><TD>3456098347</TD><TD>14/09/22</TD></TR><TR><TD>ONC_1P/AABBC-6</TD><TD>110</TD><TD>ACH</TD><TD>16/03/55</TD><TD>8765234509</TD><TD>19/09/22</TD></TR><TR><TD>ONC_A1/01234-A</TD><TD>111</TD><TD>TIU</TD><TD>12/12/08</TD><TD>5647389098</TD><TD>18/09/22</TD></TR><TR><TD>ONC-01/01234$7</TD><TD>112</TD><TD>JLL</TD><TD>23/10/80</TD><TD>2345671671</TD><TD>18/09/22</TD></TR><TR><TD><A href="mailto:ONC_AP@01234-9" target="_blank" rel="noopener">ONC_AP@01234-9</A></TD><TD>113</TD><TD>CFN</TD><TD>07/15/1986</TD><TD>9900696375</TD><TD>17/09/22</TD></TR><TR><TD>123_01/01234-6</TD><TD>114</TD><TD>SCR</TD><TD>01-Sep-78</TD><TD>6474893763</TD><TD>18/09/22</TD></TR><TR><TD>ONC-AP/ABCDE-2</TD><TD>115</TD><TD>ASO</TD><TD>02-Mar-87</TD><TD>7653225839</TD><TD>19/09/22</TD></TR><TR><TD>ONC_AP/01234-E</TD><TD>116</TD><TD>ACY</TD><TD>03-Mar-03</TD><TD>6432875875</TD><TD>18/09/22</TD></TR><TR><TD>123_AP/01234-6</TD><TD>117</TD><TD>BBE</TD><TD>04/01/90</TD><TD>5627483920</TD><TD>19/09/22</TD></TR><TR><TD>ONC_AP/12345-C</TD><TD>118</TD><TD>BBY</TD><TD>05/02/50</TD><TD>3456098347</TD><TD>15/09/22</TD></TR><TR><TD>ON _AP/01234-5</TD><TD>119</TD><TD>AAC</TD><TD>06/03/55</TD><TD>8765234509</TD><TD>13/09/22</TD></TR><TR><TD>ONC_&nbsp; /01234-4</TD><TD>120</TD><TD>ACH</TD><TD>07/12/08</TD><TD>5647389098</TD><TD>16/09/22</TD></TR><TR><TD>ONC_</TD><TD>121</TD><TD>TIU</TD><TD>08/10/80</TD><TD>5627483920</TD><TD>19/09/22</TD></TR><TR><TD>ONC_AP/</TD><TD>122</TD><TD>JLL</TD><TD>09/15/1986</TD><TD>3456098347</TD><TD>15/09/22</TD></TR><TR><TD>ONC_AP/ABC34-4</TD><TD>123</TD><TD>CFN</TD><TD>17/15/1986</TD><TD>8765234509</TD><TD>17/09/22</TD></TR></TBODY></TABLE><P>&nbsp;This my raw data , in this data , i want find the correct protocol format&nbsp; my protocol format is first letters 3 alphabets,4th position is underscore, 5th to 6th position is alphabets,7th position backward slash , after 7th to 12th position value values after 13th position '-' , 14th to 15th position&nbsp; value. eg (apc_ec/01234-43), how to verify each value in&nbsp; protocol variable , anyone can please me .</P> Tue, 20 Sep 2022 10:22:25 GMT https://communities.sas.com/t5/SAS-Procedures/how-to-check-QA-of-protocol-variable/m-p/834246#M82051 sas_university 2022-09-20T10:22:25Z Re: how to check QA of protocol variable ,. https://communities.sas.com/t5/SAS-Procedures/how-to-check-QA-of-protocol-variable/m-p/834323#M82053 <P><SPAN>Sounds like a job for a regular expression.&nbsp;</SPAN></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>[rest of response deleted]</P> Tue, 20 Sep 2022 18:25:46 GMT https://communities.sas.com/t5/SAS-Procedures/how-to-check-QA-of-protocol-variable/m-p/834323#M82053 HB 2022-09-20T18:25:46Z Re: how to check QA of protocol variable ,. https://communities.sas.com/t5/SAS-Procedures/how-to-check-QA-of-protocol-variable/m-p/834340#M82054 <P>Code provided here:&nbsp;<A href="https://communities.sas.com/t5/SAS-Programming/verify-the-format/td-p/834130" target="_blank">https://communities.sas.com/t5/SAS-Programming/verify-the-format/td-p/834130</A></P> Tue, 20 Sep 2022 17:58:44 GMT https://communities.sas.com/t5/SAS-Procedures/how-to-check-QA-of-protocol-variable/m-p/834340#M82054 PaigeMiller 2022-09-20T17:58:44Z Re: how to check QA of protocol variable ,. https://communities.sas.com/t5/SAS-Procedures/how-to-check-QA-of-protocol-variable/m-p/834349#M82055 <P>I hate that.&nbsp; So somebody got a homework assignment or a job contract someplace and posted the same issue multiple times.&nbsp; I think I'll delete my response.&nbsp;</P> <P>&nbsp;</P> Tue, 20 Sep 2022 18:24:53 GMT https://communities.sas.com/t5/SAS-Procedures/how-to-check-QA-of-protocol-variable/m-p/834349#M82055 HB 2022-09-20T18:24:53Z