topic Re: How to put validation checks for column values in SAS Programming

How to put validation checks for column values

kajal_30 — Tue, 06 Feb 2024 20:45:37 GMT

I have an excel file where I need to validate column values before I load it to the actual dataset.

custno which is a char column and reqid which is numeric column.

Tried below 2 options in my code but they didn't work.

if (is number(number)) error_message = "it is not  a number" ;
if digit(number)>0 then put 'wrong var'  ;

Re: How to put validation checks for column values

sbxkoenk — Tue, 06 Feb 2024 22:07:18 GMT

Look at these SAS functions :

ISALPHA
ISNUMBER
ANYALPHA
NOTALPHA
ANYALNUM
ANYDIGIT
NOTDIGIT
ANYPUNCT

Koen

Re: How to put validation checks for column values

SASKiwi — Wed, 07 Feb 2024 00:10:24 GMT

Did you check your SAS log? Both of these statements contain syntax errors and the SAS log will contain error messages pointing out where these are.

Re: How to put validation checks for column values

rvikram — Wed, 07 Feb 2024 02:22:51 GMT

Kajal,

If — then — else

if (is number(number)) error_message = "it is not a number" ; — missing then keyword

if digit(number)>0 then put 'wrong var' ;
Missing column name assignment.