What type of variable has the STATUS information? Is it numeric or character? Does it have a display format attached to it? Which one.
If the variable is character and does not have a format that changes how it is displayed attached then you need to make sure to use the same case letters and include any leading spaces (trailing spaces are ignored). 'Fraud' is different than 'FRAUD' or 'fraud' or ' Fraud'.
data want;
set have;
where upcase(left(status)) = 'FRAUD' ;
run;
If the variable is numeric and has a user defined format attached to it that prints the values like Fraud then you need to know what actual numbers the format maps to Fraud.
data want;
set have;
where status = 1 ;
run;
Or you could use a subsetting IF statement instead of WHERE statement. Then you could use the VVALUE() function to test the value as displayed by the format without needing to know the name of the format.
data want;
set have;
if 'Fraud' = vvalue(status);
run;
... View more
