find out variable contains only numeric

[sunilreddy]

Any way to find out the variables contains only digits(0 to 9)

data have;

input var $;

cards;

23,32

12.32

32 42

23ab

$23

123

;

run;

I want only last record(var=123) in target table, which doesn't have any alphabetic or special characters. Also i want to throw it to error table for remaining records(1 to 5 records in above example)

[art297]

The way you are creating your input file will get you the wrong results.  You have to add an ampersand on your input statement.

However, that said, try the following:

data have;

input var $ &;

cards;

23,32

12.32

32 42

23ab

$23

123

;

run;

data want errors;

  set have;

  if notdigit(strip(var)) then output errors;

  else output want;

run;