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;
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: