10-29-2014 04:15 PM
I have to prepare a SAS dataset. I have a census tract field. The final field has to contain 11 digits and should be a character variable. At present, its a numeric variable of default length 8 and best12. format. Some of the numbers are 11 digits and some are 9 digits. Initially , the 11 digit numbers had a 2 digit decimal point (i.e. 123456756.76) . I took of the decimal points using compress function as per requirements of the program. Maybe I should not have done that initially. Now, I need to add 2 trailing zeros to only those values with 9 digits. Is there something I need to do about leading or trailing blanks too.Please advise.
Initial file : numeric data , length 8 and best12. format.
Need further help from the community? Please ask a new question.