topic Re: Determine current set of allowed characters to represent special missing values on input in SAS Programming

Determine current set of allowed characters to represent special missing values on input

Tom — Mon, 18 Oct 2021 01:54:31 GMT

Does anyone know whether SAS store the current setting created by using the MISSING statement?

The MISSING statement is different than the MISSING= option. Then MISSING= option controls how missing values are displayed. You can use the GETOPTION() function to retrieve the current setting.

The MISSING statement determines which single letter text strings numeric inputs will treat as representing the corresponding special missing value. So using:

missing AB ;
input num ;

Will read "A" and "B" as meaning .A and .B, but treat "C" and "D" as invalid values that generate an error.

Re: Determine current set of allowed characters to represent special missing values on input

Tom — Mon, 18 Oct 2021 02:07:54 GMT

If SAS does not store this somewhere that can be retrieved here is a data step than can create a macro variable with the list.

data _null_;
  missing='_ABCDEFGHIJKLMNOPQRSTUVWXYZ';
  do i=1 to 27;
    if .=input(char(missing,i),??1.) then substr(missing,i,1)=' ';
  end;
  call symputx('missing',compress(missing));
run;

Example:

2681   missing azybc;
2682   data _null_;
2683     missing='_ABCDEFGHIJKLMNOPQRSTUVWXYZ';
2684     do i=1 to 27;
2685       if .=input(char(missing,i),??1.) then substr(missing,i,1)=' ';
2686     end;
2687     call symputx('missing',compress(missing));
2688   run;

NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds


2689
2690   %put &=missing;
MISSING=ABCYZ

Re: Determine current set of allowed characters to represent special missing values on input

andreas_lds — Mon, 18 Oct 2021 06:45:00 GMT

Interesting, the missing statement "is global in scope" (the docs say so), but it seems that there is no view in sashelp storing the value. For other global statements, like title, filename, ... views exist. Seems as someone forgot to implement this, or i need to look closer.

Re: Determine current set of allowed characters to represent special missing values on input

Kurt_Bremser — Mon, 18 Oct 2021 07:10:52 GMT

IMO, the MISSING statement should be deprecated and replaced by an INMISSING option.

Re: Determine current set of allowed characters to represent special missing values on input

andreas_lds — Mon, 18 Oct 2021 07:17:50 GMT

@Kurt_Bremser wrote:

IMO, the MISSING statement should be deprecated and replaced by an INMISSING option.

Well, but the "inmissing" option is no in the docs and at with m5 i get

 ERROR 13-12: Unrecognized SAS option name INMISSING.

Re: Determine current set of allowed characters to represent special missing values on input

Kurt_Bremser — Mon, 18 Oct 2021 07:27:20 GMT

That's why I said an INMISSING option, and not the INMISSING option. Such an option would need to be created. I should have written "replaced by a future INMISSING option" for clarity.