Hi Everyone. I have data like... data nn; input id res $30.; cards; 101 33 102 35 103 22 104 <23 105 <55 105 Above 33.3 106 normal 107 abnormal,1.1 108 active,2.3 109 Above 1 110 <44 ; I need output like.... ID res Num Char 101 33 33 102 35 35 103 22 22 104 <23 <23 105 <55 <55 105 Above 33.3 Above 33.3 106 normal normal 107 abnormal,1.1 1.1 abnormal 108 active,2.3 2.3 active 109 Above 1 Above 1 110 <44 <44 I have used compress function.. num=compress(res,"0123456789.","K"); char= compress(res,"0123456789,"); But Im getting wrong result for few records like ID's 105,106,109,110 for example <23 we should keep in char not in num and for 105 and 110 records we should keep it like as it is in char example.."Above 33.3" And if we have ',' in result we can separate it as like 107 and 108 in output Could anyone please assist me for how to do this task..it would be great help for me Thanks
... View more
