Thank you very much Tilea. Your suggestions were of great help. regards, Murali. ... View more

    new_sample = prxchange("s/.*[-]//i",1,(sample)); could u please tell me what i have to place in s and i ... View more

Hi Antea, Following is my data. Data sample: Set sample; Amd1_9-; AMD1_10-; Run; AMD1_9-History of another malignancy within the previous 5 years other than curatively treated non- melanomatous skin cancer AMD1_10-Current or prior treatment with estrogens and/or drugs with anti-androgenic properties such as spironolactone > 50mg/kg, or progestational agents for the treatment of prostate cancer less than 6 months prior to randomization . I need my new variable sample: "History of another malignancy within the previous 5 years other than curatively treated non- melanomatous skin cancer" ... View more

its  working but my last char in word is truncating ex :fever as feve  . could u tell me any other way ... View more

Hi Linlin and Tilea, Thank both of you for your help. I really appreciate your input. Could you please help me with the following one too. Data sample: Set sample; Amd1_9-; AMD1_10-; Run; AMD1_9-History of another malignancy within the previous 5 years other than curatively treated non- melanomatous skin cancer AMD1_10-Current or prior treatment with estrogens and/or drugs with anti-androgenic properties such as spironolactone > 50mg/kg, or progestational agents for the treatment of prostate cancer less than 6 months prior to randomization . In my variable sample I have two sets of values one is 7 char in length second set is 8 char in length I need to just remove up to colon part and my variable should be starting from alphabets. Can u Please help me out. ... View more

Thanks Lin lin. but when I have "-" in the middle its getting removed too. For instance in the following example for the third value "-a-b" have "-" at the begining and the middle also. data have; input v$; cards; abc -bc -a-b ; When I tried the following code, if first(v)='-' then v=compress(v,'-'); My output is : abc bc ab but the required output is (i.e If there is any "_" in the middle other than first position I need to keep it as is) abc bc a-b Please help. ... View more

However it worked but in my values there are '-' in middle too those are removing too. so i just need to remove only the first position of value only For '-'. ... View more

Thanks Tilea. That worked perfectly. ... View more