I did not download your spreadsheet. You can use these instructions to convert the output from PROC IMPORT into data step code we can use.   Most likely, there is a non-printable (invisible) character(s) in F1 and thus the contents of F1 cannot be converted to a number. You can use the COMPRESS function to remove characters you don't want, or keep characters you do want. In this case, we want to keep digits, the dot, and possibly commas and a hyphen to indicate a negative number. So this will do the job:   data want; set have; f1_numeric=input(compress(f1,'.,-','dk'),best32.); run;    ... View more

@hellohere wrote: I need y2axis=0 is always there wether the range is [-5, 20] or [5, 20]. This is why we need rules and not examples.   "I need y2axis=0 is always there" is a clear rule, hard to misunderstand.   "wether the range is [-5, 20] or [5, 20]" are examples which are misleading and incomplete. Both myself and Quentin have been misled by this into not considering the case where both the minimum and maximum are negative.   Now, there is a detail in the problem description which you have not mentioned. Do you have to have a tick mark and the value of 0 appear on the Y2AXIS? Or does the Y2AXIS simply have to cover zero, with perhaps tick marks at -15 -5 5 15 and no tick mark at zero?   ... View more