Current dataset in excel
MONITER_ID	DATE_REC	A_STATUS	A_ID	B_STATUS	B_ID	C_STATUS	C_ID	ARC_NAM	ARC_DAT
MONI_ID1	2/3/2016	YES		1	NO		2	YES		5	ADAM	3/9/2016
MONI_ID2	3/3/2016	NO		2	YES		3	YES		6	KAN	8/9/2016
MONI_ID3	4/3/2016	NO		3	Complete	1	complete	7	KAN	9/9/2016
MONI_ID4	6/3/2016	YES		4	NO		2	YEs		8	ADAM	10/9/2016






Expected dataset in SAS
MONITER_ID	STATUS	       VALUE	ID_CODE
MONI_ID1	A_STATUS	YES	1
MONI_ID1	B_STATUS	NO	2
MONI_ID1	C_STATUS	YES	5
MONI_ID1	A_STATUS	NO	2
MONI_ID1	B_STATUS	YES	3
MONI_ID1	C_STATUS	YES	6
MONI_ID1	A_STATUS	NO	3
MONI_ID1	B_STATUS	Com	1
MONI_ID1	C_STATUS	com	7
MONI_ID1	A_STATUS	YES	4
MONI_ID1	B_STATUS	NO	2
MONI_ID1	C_STATUS	YEs	8