Why my SAS doesn't have CMISS function?
It appeared in version 9.2 I think.
It appeared in version 9.2 I think.
Or you made a mistake somewhere else in the code or usage.
Post the full code/log and your SAS version.
2142 data txn_contactlesscmiss;
2143 set db2dw.acarddet;
2144 where dTran between '01JAN2017'd and '28FEB2017'd
2145 and (cPOSMode in ('07')
2146 or (cPOSMode in ('90','02')
2147 and cmiss(cToken, cPvder, idTReq) = 0));
ERROR: Function/subroutine CMISS not found
2148 run;
I think this part of the log file you're looking for.
If you have low version sas. there is an alternative way. data x; input (a b c) ($); cards; w e . s f d ; run; data want; set x; array x{*} $ _character_; n_miss=cmiss(of x{*}); /*alternative way*/ _n_miss=0; do i=1 to dim(x); if missing(x{i}) then _n_miss+1; end; if _n_miss=1 then put 'xxx'; run; proc print;run;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.