Hi, Thank you for the response....I was finally able to try your suggeste code today...so for the splitting of the age group, the "t" from the word "to" still remains in agegroup1 Also, I get the following error in the conversion code: NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended. ERROR 22-322: Syntax error, expecting one of the following: a quoted string, a numeric constant, a datetime constant, a missing value, iterator, (, ), ','. ERROR 76-322: Syntax error, statement will be ignored. at the end of these lines: if index(agegroup1,'year') > 0 then from = input(compress(agegroup1,,'A'),best.)/12; else if index(agegroup2,'year') > 0 then upto= input(compress(agegroup2,,'A'), best.)/12; else if index(agegroup2,'hour') > 0 then upto = input(compress(agegroup2,,'A'), best.)/(30*24);
... View more