Alternative way to write code for missing values?

[AJS1]

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;

[data_null__]

---

@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;

[AJS1]

Does cmiss represent "character missing"?

[data_null__ · Accepted solution]

Counts the number of missing arguments.

Category:

Descriptive Statistics