08-25-2016 09:02 AM
I have a list of lab values in a character variable, and I need to store all the numeric values in a numeric variable. I thought I had it made when I found the NOTDIGIT() function. That works great for integer data, but then I realized that I am dealing with decimal and negative values. Is there a way to detect just these characters? I know I could just use INPUT(). That would convert any number-like value to numeric, but for all the character values, I would be left with a lot of ugly notes filling up my log (NOTE: Invalid argument to function INPUT at line XXX column YYY.).
I have some example data below. Is there away to get LABVAL to the NUMLAB and CHARLAB, respectively, as I have them?
|< 2.5||< 2.5|
Need further help from the community? Please ask a new question.