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;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.