hello,
i have a huge data set (over 6 million). one of my variables is age which is a numeric var stored as float. i created this from a variable that was a string variable using the encode command. however, i realized that some of the data was mixed up in some observations in that some of the entries for age were not numbers but alpha characters and even words. how can i search the numeric variable age for these alpha characters and replace or drop them from my data list. im guessing there are around 80 of these so they are impossible to find with naked eye
thanks
vishal
i have a huge data set (over 6 million). one of my variables is age which is a numeric var stored as float. i created this from a variable that was a string variable using the encode command. however, i realized that some of the data was mixed up in some observations in that some of the entries for age were not numbers but alpha characters and even words. how can i search the numeric variable age for these alpha characters and replace or drop them from my data list. im guessing there are around 80 of these so they are impossible to find with naked eye
thanks
vishal
Comment