topic ERROR: Function/subroutine CMISS not found in SAS Programming

ERROR: Function/subroutine CMISS not found

afiqcjohari — Tue, 21 Mar 2017 02:12:23 GMT

Why my SAS doesn't have CMISS function?

Re: ERROR: Function/subroutine CMISS not found

ChrisNZ — Tue, 21 Mar 2017 02:29:03 GMT

It appeared in version 9.2 I think.

Re: ERROR: Function/subroutine CMISS not found

Reeza — Tue, 21 Mar 2017 03:12:03 GMT

Or you made a mistake somewhere else in the code or usage.

Post the full code/log and your SAS version.

Re: ERROR: Function/subroutine CMISS not found

Ksharp — Tue, 21 Mar 2017 03:24:58 GMT


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;

Re: ERROR: Function/subroutine CMISS not found

afiqcjohari — Tue, 21 Mar 2017 06:12:24 GMT

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.

Re: ERROR: Function/subroutine CMISS not found

afiqcjohari — Tue, 21 Mar 2017 06:14:31 GMT

I just figured out that the server is running a 9.1 version while my desktop is on 9.3

Re: ERROR: Function/subroutine CMISS not found

afiqcjohari — Tue, 21 Mar 2017 06:47:42 GMT

Hi Ksharp, thanks for this alternative suggestion!