@Reeza wrote: From your shown data SCAN() would work, so I suspect not all your data is as shown then? Can you elaborate on how SCAN() does not work? Your statement: But sas is unable to capture the (x,*, blank). Your output data however shows none of that information, so what exactly do you want? I would assume one of these would work: x = scan(variable, 1); y = scan(variable, 1, "/");
Because the decimal is a default delimiter in SCAN I think to get the "number" part you want
x = scan(variable, 1,' '); to force just getting the first bit of numbers.
And to get a numeric value:
x = input (scan(variable,1,' '),f8.);
... View more