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;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.