Dear, I have a variable(clist) has values. CLIST 1. ATC|N|NERVOUS SYSTEM; ATC|N06|PSYCHOANALEPTICS; ATC|N06B|PSYCHOSTIMULANTS, AGENTS USED FOR ADHD AND NOOTROPICS; ATC|N06BA|CENTRALLY ACTING SYMPATHOMIMETICS; PRODUCT|062107 01 001|ARMODAFINIL; PRODUCTSYNONYM|062107 01 002|NUVIGIL; 2.ATC|R|RESPIRATORY SYSTEM; ATC|R05|COUGH AND COLD PREPARATIONS; ATC|R05X|OTHER COLD PREPARATIONS; PRODUCT|000558 01 001|VICK VAPOUR-RUB; PRODUCTSYNONYM|000558 01 002|VICKS VAPORUB /00055801/; I need to extract the ATC values(ATC values start with ATC) from it into 4 variables; By using the following code I am getting the expecting output for first observation. But for second observation, eventhough 4th ATC value is missing but values are populated for CMATC4 and CMATC4C. The values for CMATC4 and CMATC4C should be blank as there is no 4th ATC. Please help Code used: CMATC1 = scan(clist,3,'|;/'); CMATC1C = scan(clist,2,'|;/'); CMATC2 = scan(clist,6,'|;/'); CMATC2C = scan(clist,5,'|;/'); CMATC3 = scan(clist,9,'|;/'); CMATC3C = scan(clist,8,'|;/'); CMATC4 = scan(clist,12,'|;/'); CMATC4C = scan(clist,11,'|;/'); expecting for the output: for first observation: CMATC1C= 'NERVOUS SYSTEM'; CMATC1='N'; CMATC2C='PSYCHOANALEPTICS'; CMATC2='N06'; CMATC3C='PSYCHOSTIMULANTS, AGENTS USED FOR ADHD AND NOOTROPICS'; CMATC3='N06B'; CMATC4C='CENTRALLY ACTING SYMPATHOMIMETICS'; CMATC4='N06BA'; for second observation: CMATC1C= 'RESPIRATORY SYSTEM'; CMATC1='R'; CMATC2C='COUGH AND COLD PREPARATIONS'; CMATC2='R05'; CMATC3C='OTHER COLD PREPARATIONS'; CMATC3='R05x'; CMATC4C=''; CMATC4='';
... View more
