I have a data set, for some reason, there are 60 character variables (var1, var2, ... var60) which they should be numeric. How to convert them to numeric? Those variable names don't follow any pattern, they are just random names, eg, var1's name is apple, var2's name is car... etc... Use input(var, format) function to replace one by one is unrealistic. There are some other variables which must remain as character, for example, organization name (which are letters ), and organization ID (which are numbers stored as character). For those 60 variables, they are numbers but somehow incorrectly stored as "character".
... View more