topic Only numbers in SAS Programming

Only numbers

SASPhile — Tue, 24 Sep 2019 15:24:13 GMT

If data contains only digits or digits with decimals then would like to create a column "want" and assign those records to the column. tried compress function but it is compressing decimals too.
Rawdata
UNKNOWN
37.5/25
37.5-25
0.25
25
10
1000IU

Rawdata want
UNKNOWN
37.5/25
0.25 0.25
25 25
10 10
1000IU

Re: Only numbers

Astounding — Tue, 24 Sep 2019 15:28:09 GMT

This should do it:

want = input(rawdata, ??16.);

Since you didn't specify, this approach assumes you would like the new variable to be numeric, not character.

Re: Only numbers

SASPhile — Tue, 24 Sep 2019 15:34:27 GMT

Yes want is only Numeric an would like want_char with remaining values

Re: Only numbers

Astounding — Tue, 24 Sep 2019 15:43:36 GMT

If you would like to add WANT_CHAR as well, it's easy enough:

want = input(rawdata, ??16.);
if want = . then want_char = rawdata;