how to check QA of protocol variable ,.

[sas_university]

Protcol ID/NO	Site ID	Subject Id	DOB	Acc NO.	SC Date
ONC_AP/01234-1	101	ABC	15-Jul-78	2345671671	16/09/22
ONC_AP/01234-2	102	BBC	21-Jun-87	9900696375	18/09/22
ONC_AP/01234-3	103	BBD	10-Sep-03	6474893763	17/09/22
ONC_AP/01234-4	104	BAC	18/08/90	7653225839	16/09/22
ONC_AP/01234-5	105	ACF	16/07/50	6432875875	14/09/22
ONC_AP/01234-6	101	TGU	16/08/55	5627483920	19/09/22
ONC_AP/01234-7	102	JKL	12/07/08	3456098347	18/09/22
ONC_AP/01234-8	101	AFN	23/02/80	8765234509	18/09/22
ONC_AP/01234-9	104	SLR	07/05/86	5647389098	17/09/22
ONC_AP/01234-10	105	ASR	19/12/83	2345671671	18/09/22
ON1_AP/01234-2	10A	_ABC	12-Jul-78	9900696375	19/09/22
O1C_AP/01234-2	A02	1BC	20-Jun-87	6474893763	18/09/22
1NC_AP/01234-4	#03	_1BD	10-Sep-03	7653225839	19/09/22
ONC1_AP/01234-6	1Q4	_111	18/08/90	6432875875	15/09/22
ONC_1P/01234-6	ab5	AC-	16/07/50	5627483920	13/09/22
ONC_A1/01234-7	a@c	101_TGU	16/08/55	3456098347	16/09/22
ONC-01/01234-7	aaa	102-JKL	12/07/08	8765234509	19/09/22
ONC_#P/01234-9	a0a	103@AFN	23/02/80	5647389098	15/09/22
ONC_AP*01234-10	#3#	102_a10-	07/05/86	2345671671	17/09/22
ONC_AP/A1234-2	10_	ASR_100	19/12/83	9900696375	19/09/22
ONC_AP/0A234-1	101-	/scf	15-Sep-78	6474893763	16/09/22
ON1_AP/01A34-2	106	ACY	21-Mar-87	7653225839	18/09/22
O1C_AP/012A4-2	107	BBE	10-Mar-03	6432875875	17/09/22
1NC_AP/0123A-4	108	BBY	18/01/90	5627483920	16/09/22
ONC1_AP/01234_6	109	AAC	16/02/50	3456098347	14/09/22
ONC_1P/AABBC-6	110	ACH	16/03/55	8765234509	19/09/22
ONC_A1/01234-A	111	TIU	12/12/08	5647389098	18/09/22
ONC-01/01234$7	112	JLL	23/10/80	2345671671	18/09/22
ONC_AP@01234-9	113	CFN	07/15/1986	9900696375	17/09/22
123_01/01234-6	114	SCR	01-Sep-78	6474893763	18/09/22
ONC-AP/ABCDE-2	115	ASO	02-Mar-87	7653225839	19/09/22
ONC_AP/01234-E	116	ACY	03-Mar-03	6432875875	18/09/22
123_AP/01234-6	117	BBE	04/01/90	5627483920	19/09/22
ONC_AP/12345-C	118	BBY	05/02/50	3456098347	15/09/22
ON _AP/01234-5	119	AAC	06/03/55	8765234509	13/09/22
ONC_  /01234-4	120	ACH	07/12/08	5647389098	16/09/22
ONC_	121	TIU	08/10/80	5627483920	19/09/22
ONC_AP/	122	JLL	09/15/1986	3456098347	15/09/22
ONC_AP/ABC34-4	123	CFN	17/15/1986	8765234509	17/09/22

 This my raw data , in this data , i want find the correct protocol format  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  value. eg (apc_ec/01234-43), how to verify each value in  protocol variable , anyone can please me .

[HB · Accepted solution]

Sounds like a job for a regular expression. 

[rest of response deleted]

[PaigeMiller]

Code provided here: https://communities.sas.com/t5/SAS-Programming/verify-the-format/td-p/834130

[HB]

I hate that.  So somebody got a homework assignment or a job contract someplace and posted the same issue multiple times.  I think I'll delete my response.