topic Alternative way to write code for missing values? in New SAS User

Alternative way to write code for missing values?

AJS1 — Tue, 07 Jan 2020 15:10:49 GMT

proc print data=pg1.eu_occ;
    where Hotel is missing and ShortStay is missing and 
          Camp is missing;
run;

Is there a "shortcut" code to the WHERE statement? Why can't you use: WHERE Hotel and ShortStay and Camp is missing;

Re: Alternative way to write code for missing values?

data_null__ — Tue, 07 Jan 2020 15:16:58 GMT

@AJS1 wrote:
proc print data=pg1.eu_occ;
    where Hotel is missing and ShortStay is missing and 
          Camp is missing;
run;
Is there a "shortcut" code to the WHERE statement? Why can't you use: WHERE Hotel and ShortStay and Camp is missing;

Because that syntax is invalid.

35         proc print data=sashelp.class;
36            where cmiss(name,age,weight) eq 3;
37            run;

NOTE: No observations were selected from data set SASHELP.CLASS.
NOTE: There were 0 observations read from the data set SASHELP.CLASS.
      WHERE CMISS(name, age, weight)=3;

Re: Alternative way to write code for missing values?

AJS1 — Tue, 07 Jan 2020 16:17:05 GMT

Does cmiss represent "character missing"?

Re: Alternative way to write code for missing values?

data_null__ — Tue, 07 Jan 2020 17:10:38 GMT

Counts the number of missing arguments.

Category:

Descriptive Statistics